topic Re: Hide Sheet in QlikView

Hide Sheet

Wed, 03 Dec 2014 07:56:40 GMT

Hi All

How do I hide a sheet that I was doing some development so that Users won't be able to see it but don't want to delete the sheet either? I would like to use it in future again.

Re: Hide Sheet

rubenmarin — Wed, 03 Dec 2014 08:30:38 GMT

Hi, in the "General" tab of Sheet properties you can set the conditional show you can set the continional to "0" to hide the sheet. In the "sheets" tab of the document properties you can access to a hide sheet.

You can also use OSUser() function so only your user can see the sheet.

Re: Hide Sheet

ashfaq_haseeb — Wed, 03 Dec 2014 08:37:01 GMT

Hi,

Check this

http://community.qlik.com/docs/DOC-4435

Regards

ASHFAQ

Re: Hide Sheet

amit_saini — Wed, 03 Dec 2014 08:56:19 GMT

Tumelo,

go to sheet properties->under condition

Thanks,

Re: Hide Sheet

its_anandrjs — Wed, 03 Dec 2014 09:06:58 GMT

Hi,

If you want to manually hide the qlik sheets then create on variable

Let vDisplay = 1;

And in the Sheet properties >> General >> Show sheet >> Conditional write expression =vDisplay

And for visible make variable value

Let vDisplay = 0;

Regards,

Anand

Re: Hide Sheet

SunilChauhan — Wed, 03 Dec 2014 09:14:30 GMT

in Layout of sheet propeties write below conditions

Upper(osuser())='Domain\your loginname'

for example My domain is TS and i have log to windows using Sunil then

sheet properties->layout->Condition->

Upper(osuser())='TS\Sunil'

then it will visible to you only other cann't see this

Re: Hide Sheet

Wed, 03 Dec 2014 09:29:08 GMT

Thank you all for your responses. I now know how to do this in many different ways

Re: Hide Sheet

SunilChauhan — Wed, 03 Dec 2014 09:36:35 GMT

so for each time hide and show you will set variable to 1 and 0. and if you hide using Anand's suggession.

would it not hide for you also?