Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Hide the sheet

Dear all

i try to hide the sheet so i use sheet properties --> general --> show sheet--> condition = 0 for hiding the sheet, but sheet in not getting hidden.

anything i need to change in the document setting ?

please guide me...

thanks in advance

sirajahamed S

1 Solution

Accepted Solutions
Peter_Cammaert
Partner - Champion III
Partner - Champion III

Check if Settings->Document Properties->Security->Show All Sheets and Objects has been cleared.

View solution in original post

14 Replies
Peter_Cammaert
Partner - Champion III
Partner - Champion III

Check if Settings->Document Properties->Security->Show All Sheets and Objects has been cleared.

jpenuliar
Partner - Specialist III
Partner - Specialist III

Hi,

In order to Show/Hide any object using conditional show, a condition has to be met.

an example to your Conditional show would be = "A = 0" or "if variable = 1"

jpenuliar
Partner - Specialist III
Partner - Specialist III

in other other words,

If condition is met, then hide object.

It is not same as visual basic "visible" where you simply set True/False property to show/hide

Peter_Cammaert
Partner - Champion III
Partner - Champion III

Expression

=0

works equally well.

maleksafa
Specialist
Specialist

sheet properties, show sheet, conditional -> if(1=2,1,0) and as far as i know this will never happen

jpenuliar
Partner - Specialist III
Partner - Specialist III

yes it does,

But how do you trigger it to show?

I dont really use much the  " = 0" mainly, probably because i dont know how to retrigg it. lol

maleksafa
Specialist
Specialist

you can still get back to the sheet, if you go to document properties -> sheets -> select the sheet from there and go to properties and remove the condition.

jpenuliar
Partner - Specialist III
Partner - Specialist III

is it a Math Joke?

Peter_Cammaert
Partner - Champion III
Partner - Champion III

True, I only use this trick to hide worksheets that won't come out of hiding very often.

The trick to get them to show up again is fairly straightforward.

Settings->Document Properties->Sheets->Select sheet->Properties->General->Show Sheet = Always