topic Re: Toggling cyclic group value from button in QlikView

Toggling cyclic group value from button

ashis — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am trying to create a cyclic group using 3 dimension , for example Dim A, Dim B and Dim C and giving a name to group Dynamic.

Is there any way i can toggle the value of the cyclic group using button. 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.

is there any way to achieve it.

Thank you,

Re: Toggling cyclic group value from button

Sloan258 — Fri, 14 Jun 2019 10:53:57 GMT

jQuery also provides an animation method named .toggle() that toggles the visibility of elements kroger feedback.

Re: Toggling cyclic group value from button

mato32188 — Fri, 14 Jun 2019 11:47:09 GMT

Hi Ashissau,
yes, it is.

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))
- =if($(vButton)=1,DIM A,if($(vButton)=2,DIM B,DIM C))
- =if($(vButton)=1,DIM A,if($(vButton)=2,DIM B,DIM C))

Press the button to see, how your cyclic dimension is being changed in chart, pivot table, etc.

Martin

Re: Toggling cyclic group value from button

ashis — Fri, 14 Jun 2019 12:09:08 GMT

Hi Martin, Thank you so much. your solution worked.

I removed the field names from cyclic group and only kept the following expression

=if($(vButton)=1,DIM A,if($(vButton)=2,DIM B,DIM C))

And with the button the dimensions are changing. Thank you.

One thing , if i want to show the value of this Dimension in text box , how do i do it.

=GetCurrentField(groupname) - this expression does not return value , it is returning above expression of cyclic group.

Re: Toggling cyclic group value from button

ashis — Fri, 14 Jun 2019 12:27:39 GMT

I found a way to show this inside text box .

This same expression would do

=if($(vButton)=1,DIM A,if($(vButton)=2,DIM B,DIM C))

Thanks again .