Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

Tags (4)
1 Solution

Accepted Solutions
Not applicable

Re: Show/Hide Sheet dependent of listbox data selection

Here you are.

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

gr.

Frank

4 Replies
Not applicable

Show/Hide Sheet dependent of listbox data selection

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

Re: Show/Hide Sheet dependent of listbox data selection

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

Re: Show/Hide Sheet dependent of listbox data selection

Here you are.

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

gr.

Frank

Not applicable

Re: Show/Hide Sheet dependent of listbox data selection

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