Hide/show list box by clicking on a button

[#1]

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 · Accepted solution]

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

See also attached.

edit:

You might also consider using a multi box instead of list boxes to save some screen space.

[#3]

Swuehl:

It worked.

Thanks.

[#4]

Brilliant post and very helpful demo qvw.

Regards,

Amit