topic Re: Toggle Button Multiple Choices in QlikView

Toggle Button Multiple Choices

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

Hi,

I have the attached Document, at the moment when you click the Button it will switch between dimensions and measures. I want it also to incorporate "Show Filters", so after the measure I want it to only show the Multi Box only and then when the Button is clicked again it will go back to Dimensions and will only show that, hope that makes sense.

Thanks

Re: Toggle Button Multiple Choices

richard_chilvers — Tue, 10 Apr 2018 07:58:54 GMT

At the moment, your variable toggles between 2 values.

You need to change your Actions so it loops round 3 values, for example D (dimensions), M (measures), F (filters).

The conditional show in your object will need to use the relevant value in this variable.

eg. vShowMultiple = 'M' for the measures.

Re: Toggle Button Multiple Choices

ivandrago — Tue, 10 Apr 2018 08:07:17 GMT

So how would this be achievable using my current logic, not sure what to change using the current actions, would it have to be mutiple IF statements

Re: Toggle Button Multiple Choices

sasiparupudi1 — Tue, 10 Apr 2018 12:19:36 GMT

Like Attached?

Re: Toggle Button Multiple Choices

ivandrago — Tue, 10 Apr 2018 21:57:34 GMT

Thanks Sasidhar, Yes this is what I am after, but how to I get the correct Description to show on the Button for the next Object it shows next?

Re: Toggle Button Multiple Choices

ivandrago — Tue, 10 Apr 2018 22:07:10 GMT

Sorted it now, I amended it to the following:

=' Show ' &if(vShowMultiple = 1, 'Dimensions',

if(vShowMultiple = 2, 'Filters','Measures'))