Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hide Sheet


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.

1 Solution

Accepted Solutions
its_anandrjs

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

View solution in original post

7 Replies
rubenmarin

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.

ashfaq_haseeb
Champion III
Champion III

Hi,

Check this

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

Regards

ASHFAQ

amit_saini
Master III
Master III

Tumelo,

go to sheet properties->under condition

Thanks,

AS

its_anandrjs

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

SunilChauhan
Champion II
Champion II

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

Sunil Chauhan
Not applicable
Author

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

SunilChauhan
Champion II
Champion II

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?

Sunil Chauhan