topic activate multiple sheets in QlikView

activate multiple sheets

MauriceLudo — Fri, 16 Dec 2016 13:07:57 GMT

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

Re: activate multiple sheets

Anonymous — Fri, 16 Dec 2016 13:33:54 GMT

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.

Re: activate multiple sheets

Anonymous — Fri, 16 Dec 2016 13:50:53 GMT

After creating variable,

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

then,

go to the sheet properties

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

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

Thanq.

Re: activate multiple sheets

MauriceLudo — Mon, 19 Dec 2016 11:52:47 GMT

Hello,

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

here is an example thank you

Re: activate multiple sheets

ganeshsvm — Mon, 19 Dec 2016 12:50:46 GMT

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.

Re: activate multiple sheets

MauriceLudo — Mon, 19 Dec 2016 13:49:50 GMT

Hi Ganesh,

it does not work can you please look her thank you

Re: activate multiple sheets

ganeshsvm — Tue, 20 Dec 2016 10:00:55 GMT

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

PFA,

Check and lemme kno.