Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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.
Tumelo,
go to sheet properties->under condition
Thanks,
AS
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
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
Thank you all for your responses. I now know how to do this in many different ways
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?