How can I create cyclic expression in Qlikview?




As we can create cyclic group of dimensions, can we also create a group for expression? This can helps us to optimize the sheet space where we can represent multiple metrics in a single chart object.




Having a cyclic expression in your chart will have the ability to interactively change the measure or formula used. Now, let’s look at the method to create cyclic expression.

Step1:- Create all expressions individually (Like below, I have created two expressions NOP and Sales)

Step2:- Select the most expression and click on Group Command. Now, you can see that expressions are grouped.

Now, at front end you can see that you can switch between these grouped expressions.

Hope this helps!