Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I am new in QlikView, and i am trying to create a condition to show a hidden sheet by clicking in a button or some object.
The idea is to show the hidden sheet only when the user clicks in that button or object.
After the user clicks in another sheet, then it must be hidden again.
Regards,
Rodrigo
Create a variable: vShowSheet
Set the button's action to change the variable to "Yes".
Set the sheets show condition to =vShowSheet = 'Yes'
For all other sheets, set their on activate trigger to set the variable to "No"
Create a variable: vShowSheet
Set the button's action to change the variable to "Yes".
Set the sheets show condition to =vShowSheet = 'Yes'
For all other sheets, set their on activate trigger to set the variable to "No"
Here you have an example
Thans for your help M Woolf.
I forgot to say... Also, when user click on that button the sheet must be activated, i mean, the user will see the content from the hidden sheet.
Thanks
After setting the variable to "Yes" add a second action that activates the sheet.
Thans for the tip M Woolf, it worked fine.
Regards
Hi,
Here is an example. If you look I created a variable called hide. I am changing the variable with the buttons and the Show Sheet Conditional on the sheet properties and General tab.
There are two buttons one to show and one to hide at the top. The other button at the bottom are two buttons on top of each other. They are also using the hide variable to only show one button at a time.
Bill