topic Re: Cannot hide sheet in QlikView

Cannot hide sheet

Thu, 04 Sep 2014 07:57:44 GMT

I have tried using a vShowHideSheet variable and setting the value to 0. I have also tried simply typing in 0, but i cannot hide any sheets on this document!

Both methods work on other documents i use.

Is there another setting which is over-riding this that i don't know about? Help, it's driving me mad!

Re: Cannot hide sheet

michael_maeuser — Thu, 04 Sep 2014 07:59:46 GMT

Hi,

shouldn´t your variable vShowHideSheet be in the coditional field?

Re: Cannot hide sheet

Anonymous — Thu, 04 Sep 2014 07:59:59 GMT

you Need to enter a condition

for instance 1=0 will hide the sheet

vShowHideSheet = 1 will Show the sheet if variable is 1

Re: Cannot hide sheet

alexandros17 — Thu, 04 Sep 2014 08:00:22 GMT

in "conditional" you must write:

vShowHideSheet <>0

let me know

Re: Cannot hide sheet

ashfaq_haseeb — Thu, 04 Sep 2014 08:01:24 GMT

Hi,

write below in your conditional field

vShowHideSheet=1

Regards

ASHFAQ

Re: Cannot hide sheet

Thu, 04 Sep 2014 08:05:13 GMT

as I said, i have tried that. I doesn't work either

Re: Cannot hide sheet

Thu, 04 Sep 2014 08:05:59 GMT

as I said, i have tried that. I doesn't work either

See new screenshots above

Re: Cannot hide sheet

michael_maeuser — Thu, 04 Sep 2014 08:06:28 GMT

again, i your conditio field just write =vShowHideSheet . you don´t need =vShowHideSheet =1 or s.th. like that

Re: Cannot hide sheet

Thu, 04 Sep 2014 08:06:36 GMT

doesn't work

Re: Cannot hide sheet

Thu, 04 Sep 2014 08:07:15 GMT

doesn't work

Re: Cannot hide sheet

alexandros17 — Thu, 04 Sep 2014 08:08:07 GMT

IN the box "conditional" you must write a condition so if you want that with 0 sheet disappear and with 1 reappear then write: vShowHideSheet=1

if your variable is 0 the sheet hides otherwise appear

Re: Cannot hide sheet

michael_maeuser — Thu, 04 Sep 2014 08:09:14 GMT

did you really set you variable to 0?

Re: Cannot hide sheet

ashfaq_haseeb — Thu, 04 Sep 2014 08:09:39 GMT

Hi,

Attach your sample app.

Regards

ASHFAQ

Re: Cannot hide sheet

antoniotiman — Thu, 04 Sep 2014 08:10:18 GMT

Hi Alex,

in Property Document -> Security uncheck 'Show All Sheets and Objects'

Regards,

Antonio

Re: Cannot hide sheet

michael_maeuser — Thu, 04 Sep 2014 08:10:46 GMT

can you share the app? if there´s confidential data, just scrumble it

Re: Cannot hide sheet

Thu, 04 Sep 2014 08:14:01 GMT

I have tried it with and without the = sign. neither works

Re: Cannot hide sheet

Thu, 04 Sep 2014 08:14:43 GMT

Re: Cannot hide sheet

simondachstr — Thu, 04 Sep 2014 08:15:24 GMT

That's probably it.

Re: Cannot hide sheet

Thu, 04 Sep 2014 08:16:50 GMT

Thanks Antonio!!!

So simple