QlikView App Dev

[Anonymous]

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

[Peter_Cammaert · Accepted solution]

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

[jpenuliar]

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]

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]

Expression

=0

works equally well.

[maleksafa]

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

[jpenuliar]

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]

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]

is it a Math Joke?

[Peter_Cammaert]

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