Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

MauriceLudo
Contributor 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
kalyanivintha1
Contributor II

Re: activate multiple sheets

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.

kalyanivintha1
Contributor II

Re: activate multiple sheets

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
Contributor II

Re: activate multiple sheets

Hello,

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

here is an example thank you

ganeshsvm
Contributor

Re: activate multiple sheets

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
Contributor II

Re: activate multiple sheets

Hi Ganesh,

it does not work can you please look her thank you

ganeshsvm
Contributor

Re: activate multiple sheets

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

PFA,

Check and lemme kno.

Community Browser