topic Need to associate cyclic group using a list box in QlikView

Need to associate cyclic group using a list box

ashis — Sat, 16 Nov 2024 20:38:08 GMT

Hi ,

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 .

Please advise.

Re: Need to associate cyclic group using a list box

marcus_sommer — Wed, 19 Jun 2019 11:55:19 GMT

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.

- Marcus

Re: Need to associate cyclic group using a list box

sunny_talwar — Wed, 19 Jun 2019 12:03:57 GMT

Would you be able to share a sample file where you might have been testing this? It might be easy to help with a sample

Re: Need to associate cyclic group using a list box

ashis — Thu, 20 Jun 2019 04:49:49 GMT

Hi Sunny,

Thank you for your reply. I have limitation of sharing file. Anyway i have found alternative way to get this done. Just like

creating listbox in Adhoc reporting.

Re: Need to associate cyclic group using a list box

ashis — Thu, 20 Jun 2019 04:51:03 GMT

Thank you Marcus, i wanted to put group in listbox in different way.

Thank you for your suggestion.

Re: Need to associate cyclic group using a list box

sunny_talwar — Thu, 20 Jun 2019 10:12:44 GMT

Super