Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Cannot hide sheet

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!

hide.png

18 Replies
alexandros17
Partner - Champion III
Partner - Champion III

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

michael_maeuser
Partner Ambassador
Partner Ambassador

did you really set you variable to 0?

ashfaq_haseeb
Champion III
Champion III

Hi,

Attach your sample app.

Regards

ASHFAQ

antoniotiman
Master III
Master III

Hi Alex,

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

Regards,

Antonio

michael_maeuser
Partner Ambassador
Partner Ambassador

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

Not applicable
Author

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

equals sign.png

Not applicable
Author

variables.png

simondachstr
Specialist III
Specialist III

That's probably it.

Not applicable
Author

Thanks Antonio!!!

So simple