topic Re: Hide the sheet in QlikView

Hide the sheet

Anonymous — Fri, 21 Nov 2014 12:22:39 GMT

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

Re: Hide the sheet

Peter_Cammaert — Fri, 21 Nov 2014 12:26:19 GMT

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

Re: Hide the sheet

jpenuliar — Fri, 21 Nov 2014 12:29:18 GMT

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"

Re: Hide the sheet

jpenuliar — Fri, 21 Nov 2014 12:31:47 GMT

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

Re: Hide the sheet

Peter_Cammaert — Fri, 21 Nov 2014 12:33:34 GMT

Expression

works equally well.

Re: Hide the sheet

maleksafa — Fri, 21 Nov 2014 12:36:53 GMT

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

Re: Hide the sheet

jpenuliar — Fri, 21 Nov 2014 12:38:40 GMT

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

Re: Hide the sheet

maleksafa — Fri, 21 Nov 2014 12:42:13 GMT

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.

Re: Hide the sheet

jpenuliar — Fri, 21 Nov 2014 12:43:11 GMT

is it a Math Joke?

Re: Hide the sheet

Peter_Cammaert — Fri, 21 Nov 2014 12:44:06 GMT

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

Re: Hide the sheet

maleksafa — Fri, 21 Nov 2014 12:44:54 GMT

i guess more of a math fact.

Re: Hide the sheet

jpenuliar — Fri, 21 Nov 2014 12:56:02 GMT

Yeah, i agree on that.

But is there any way to programmatically show the object?

Maybe i should post it as a new discussion...

Re: Hide the sheet

Peter_Cammaert — Fri, 21 Nov 2014 13:04:37 GMT

You mean, like adding condition

vDebug = 1

to all worksheets, and adding a button that toggles the value of vDebug with expression

=if(vDebug=1, 0, 1)

Without a button, you can change the value of vDebug in Settings->Variable Overview.

More complex handling is possible, but that all depends on what you are trying to accomplish.

Re: Hide the sheet

maleksafa — Fri, 21 Nov 2014 13:08:46 GMT

you can also go with user condition, using the OSUser() so that only you will be able to see this sheet.

Re: Hide the sheet

Anonymous — Fri, 21 Nov 2014 13:13:41 GMT

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

when i unchecked the option the sheet hidden ed

thanks for your support..