topic Re: Switch Charts using one Variable set in Button in QlikView

Switch Charts using one Variable set in Button

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

Hi,

I have the attached Document, I need help with the formula that is in on the Button, I want it to loop around the three available charts, which are Dimensions, Measures, Filters. I had this work when it was just two charts but unsure how to get this to loop around when I have three charts?

Any Ideas?

Thanks

Re: Switch Charts using one Variable set in Button

sunny_talwar — Wed, 08 Nov 2017 09:44:08 GMT

Check attached

=if(vSwitch=1, 2, If(vSwitch=2, 3, 1))

Re: Switch Charts using one Variable set in Button

Anil_Babu_Samineni — Wed, 08 Nov 2017 10:47:25 GMT

Correction based on text to Chart Titles. Text object should be this..

=' Show ' &if(vSwitch = 3, 'Filters',if(vSwitch = 1, 'Dimensions',if(vSwitch = 2,'Measures')))

Re: Switch Charts using one Variable set in Button

sunny_talwar — Wed, 08 Nov 2017 12:03:52 GMT

Thanks Anil!! I didn't even look at that as I was too much engrossed in getting the variable working

Re: Switch Charts using one Variable set in Button

ivandrago — Wed, 08 Nov 2017 12:55:28 GMT

Thanks Anil, actually what Sunny has done is what I want, as I want it to say Show Measures if the current Chart that is open is on Dimensons