Hiding a sheet

[Anonymous]

Hi all

How to hide a sheet in qlikview ?

Thanks

[mukesh24]

Hi,

Sheet Propeties --> Show Sheet --> Condition on which u need to hide sheet

Regards,

Mukesh

[Peter_Cammaert]

In Sheet Properties->General->Show Sheet, select Conditional and put 0 in the expression field. The sheet will disappear.

To get it back, goto Settings->Document Properties->Sheets->Select sheet->Properties and remove the 0 or switch back to Show Always.

[neha_sri]

Hi rgv,

To hide a sheet in qv you can go to General tab>coditional. You can write your condition when you want to open that sheet.

[#5]

the neatest way is to create a variable like vShow.. assign a value of zero to it initially.

Create a button that has an action of Set Variable, and essentially create an on/off action with :

=if(vShow=1,0,1)

Now go to the tab to be hidden, select Sheet Properties, and in the Conditional area, put =vShow

[Gabriel]

Hi,

Can i ask that you to be more clearer with your question. This will help experts to give you acurate answer.

You intend to hide a sheet from WHO, WHAT and WHEN do you intend to unhide the sheet. Do you intend to hide the sheet permantly. e.t.c

This are sort of things missing form your question

[Anonymous]

No !!! not permanently ,As of now we are not using the sheet so i would like to hide the sheet .So that later on i can restore  my sheet

Thanks

[Gabriel]

Hi,

In that case then do what Graeme Baxter suggested.

[#9]

Use the button option