I have created a cyclic group using 3 dimensions , for example Dim A, Dim B and Dim C and giving a name to group Dynamic. I am using this cyclic group in couple of my charts. Now with the help of one button i am toggling the values,Like when i click on the button the value of Dynamic group would change from Dim A to Dim B then again on click it will change to Dim C.
Below is the logic i am using;
create variable (i.e. vButton), assign default value to 1 create button with action - set variable, variable: vButton, value: =if($(vButton)=1,2,if($(vButton)=2,3,1)) create cyclic group (Edit groups) with 3 Used Fields and =if($(vButton)=1,DIM A,if($(vButton)=2,DIM B,DIM C))
Now my requirement is , i want to create a list box consist of Dim A,Dim B and Dim C and select dimension values from list box instead of togging using button. So i created a inline table LOAD * INLINE [ ValueList, Flag Dim A,1 Dim B,2 Dim C,3 ];
and created a list box ValueList, now the challenge is to associate Value of ValueList with actual Dimensions .
Such a cyclic group is a native feature in QlikView and therefore you don't need to rebuild the logic. Within the document-properties is a tab groups and it could be also accessed from the dimension-tab (bottom left) within the objects.