topic Re: Hide/show list box by clicking on a button in QlikView

Hide/show list box by clicking on a button

Wed, 14 Mar 2012 20:54:35 GMT

Hi:

My dimensional list boxes are taking lot of space on my sheet.

Therefore i want to show/hide them when a button is clicked.

I tried, by creating a variable in a button , under "Action"

vDimension_show and setting it value to 0

in the list box under layout/show , i am setting is value to 1. My List box does disappear,

but it has not affect when i click on the button.

I am sure that i am missing some step here.

Can you please help or share a sample qvw.

Also is there any other way to show dimension list boxes which can save space on the sheet.

Thanks.

swuehl — Wed, 14 Mar 2012 22:50:52 GMT

You need to create a variable, e.g. vShow in variable overview.

Then create a button with action 'External' - 'Set Variable'

Put the variable name into the appropriate field

vShow

and enter as expression

=if(vShow,0,1)

For all chart objects like list boxes you want to hide, enter as conditional show expression in layout tab

vShow

Thu, 15 Mar 2012 01:46:39 GMT

Swuehl:

It worked.

Thanks.

Thu, 15 Nov 2012 22:21:19 GMT

Brilliant post and very helpful demo qvw.

Regards,

Amit