Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Show/Hide Sheet dependent of listbox data selection

Hi can I ask exmple file for this? Thanks I really need to know how to hide/show sheet when selecting value in listbox (which is located in the other sheet)

example:

Sheet 1 has listbox, when selecting/click data on the listbox, corresponding information should be displayed/viewable on the new sheet which is sheet 2. Don't know how to do this. Need help. Thanks. ASAP thanks.

-best regards, Bill Ringer

1 Solution

Accepted Solutions
Not applicable
Author

Here you are.

The sheets are hidden/shown depending on the value of the listbox (VAR1).

gr.

Frank

View solution in original post

4 Replies
Not applicable
Author

He Bill,

By using conidtional show in the sheet properties you could hide or show a sheet depending on the value of the the listbox.

gr.

Frank

Not applicable
Author

Hi Frank,

I'm new to qlikview, don't know conditional show. Hmm do you have any example regarding my concern? Thanks.

Best regards,

Bill

Not applicable
Author

Here you are.

The sheets are hidden/shown depending on the value of the listbox (VAR1).

gr.

Frank

Not applicable
Author

Frank, I modify your script in condition property,

original: VAR1==3

modified: if(VAR1==2)

therefore, in the modified script, if var1 is not equal to 2, the sheet will hide.

Yehey, thank you so  much Frank for your time.

-bill here