Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
MauriceLudo
Creator II
Creator II

activate multiple sheets

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

Maurice

6 Replies
Anonymous
Not applicable

Hi Maurice,


it is possible to do....

initially create a variable like vshowhide

and

Create a...button object with some action.

go to button properties

in actions tab

add action

set variable in External

in that add variable as variable name and assign the value like this...

=if(vshowhide=1,0,1)

and

go to the sheets and

in sheet properties make conditional with variable.

in conditional add value like this...vshowhide=1

and

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.

Thanq.

Anonymous
Not applicable

After creating variable,

add action in button like this.........as fallows.

1.png

then,

go to the sheet properties

make conditional like this....as fallows....

2.png

you can do like this conditional on multiple sheets if you want.

Thanq.

MauriceLudo
Creator II
Creator II
Author

Hello,

I would like to make disappear all the sheet when I return on the sheet Accueil

here is an example thank you

ganeshsvm
Creator II
Creator II

Hi Maurice,

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.

Capture.PNG

MauriceLudo
Creator II
Creator II
Author

Hi Ganesh,

it does not work can you please look her thank you

ganeshsvm
Creator II
Creator II

I cannot open your app as I'm using a Personal Edition,

PFA,

Check and lemme kno.