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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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

1 Solution

Accepted Solutions
antoniotiman
Master III
Master III

Hi Alex,

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

Regards,

Antonio

View solution in original post

18 Replies
michael_maeuser
Partner Ambassador
Partner Ambassador

Hi,

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

Anonymous
Not applicable
Author

you Need to enter a condition

for instance 1=0 will hide the sheet

vShowHideSheet = 1 will Show the sheet if variable is 1

alexandros17
Partner - Champion III
Partner - Champion III

in "conditional" you must write:

vShowHideSheet <>0


let me know

ashfaq_haseeb
Champion III
Champion III

Hi,

write below in your conditional field

vShowHideSheet=1


Regards

ASHFAQ

Not applicable
Author

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

variables.png

Not applicable
Author

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


See new screenshots above

michael_maeuser
Partner Ambassador
Partner Ambassador

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

Not applicable
Author

doesn't work

Not applicable
Author

doesn't work