topic Re: Buttons to control multiple listboxes in QlikView

Buttons to control multiple listboxes

Fri, 16 May 2014 14:35:26 GMT

Hi all,

I have three buttons (Button 1, 2 and 3) which, on click, I want to replace a list box (i.e. hide the others and show the one attributed to the button, i.e. Table 1, 2 and 3). So when I click on button two, it will show Table 2, and then when I click on Button 1, I want to hide Table 2 and show Table 1 instead.

Is this possible?

Thanks!

Re: Buttons to control multiple listboxes

mjm — Fri, 16 May 2014 14:57:33 GMT

Hello,

this is definitely possible.

I have attached an example QVW where you can see how I have achieved this. This was done using a variable for each table you want to show/hide. The variables are set in Settings > Variable Overview.

The three buttons then each have an action to set these variables as either 1 or 0, 1 being show and 0 being hide.

There are then conditional shows on each table object which will only show when their corresponding variable is set to 1.

Please mark as answered if you are happy with this answer.

Re: Buttons to control multiple listboxes

Fri, 16 May 2014 15:00:29 GMT

Attached with answer.

Steps:

Create a variable say vBut (Settings > Variable Overview)
Create three text boxes and in actions go to External > Set variable and now set vBut =1 for the first one
Similar for other two boxes with 2 and 3 respectively
Now create a table and go to Conditional > Layout and set vBut=1
For tables two and three vBut=2 and 3 respectively

And thats it. make sure the variable name matches. They are case sensitive.

Thanks

Re: Buttons to control multiple listboxes

maxgro — Fri, 16 May 2014 20:10:07 GMT

if you want to hide/show 3 listbox with buttons, you can use previous answers

or in a simpler way create justa singleobject, a single listbox and use a cyclic group to show the 3 different dimensions