Discussion Board for collaboration on QlikView Layout & Visualizations.
Hi,I would like to know is what this possible to create button to activate multiple sheets at once, a sheet with several buttons each button to activate a document with multiple sheets.Best regards
it is possible to do....
initially create a variable like vshowhide
Create a...button object with some action.
go to button properties
in actions tab
set variable in External
in that add variable as variable name and assign the value like this...
go to the sheets and
in sheet properties make conditional with variable.
in conditional add value like this...vshowhide=1
make this conditional to multiple sheets.
then you are going to achieve your requirement.
after this when your clicking on the button object it is going to hide multiple sheets by the single click
and when ever you are click on that particular button object again it is going to show multiple sheets.
After creating variable,
add action in button like this.........as fallows.
go to the sheet properties
make conditional like this....as fallows....
you can do like this conditional on multiple sheets if you want.
I would like to make disappear all the sheet when I return on the sheet Accueil
here is an example thank you
You would putting the same logic on all sheets conditional show as Kalyani explained, and one additional thing to be done is, as per your requirement,
On "Accueil" sheet properties, goto Triggers tab, then click on Edit action under OnActivatesheet trigger and include the set variable option and use vshow in Variable textbox and value as 0.
it does not work can you please look her thank you
I cannot open your app as I'm using a Personal Edition,
Check and lemme kno.