topic Re: Hiding a sheet in QlikView

Hiding a sheet

Anonymous — Tue, 03 Mar 2015 08:54:18 GMT

Hi all

How to hide a sheet in qlikview ?

Thanks

mukesh24 — Tue, 03 Mar 2015 08:57:00 GMT

Hi,

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

Regards,

Mukesh

Peter_Cammaert — Tue, 03 Mar 2015 08:58:41 GMT

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 — Tue, 03 Mar 2015 08:59:21 GMT

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.

Tue, 03 Mar 2015 09:30:41 GMT

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 — Tue, 03 Mar 2015 09:40:17 GMT

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 — Tue, 03 Mar 2015 09:53:08 GMT

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 — Tue, 03 Mar 2015 10:01:36 GMT

Hi,

In that case then do what Graeme Baxter suggested.

Tue, 03 Mar 2015 10:06:08 GMT

Use the button option