Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Here you are.
The sheets are hidden/shown depending on the value of the listbox (VAR1).
gr.
Frank
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
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
Here you are.
The sheets are hidden/shown depending on the value of the listbox (VAR1).
gr.
Frank
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