Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Conditional display of sheet in version 8.5

It is possible to use a macro for hide or display a sheet with conditional expression?

Thanks

Master

2 Replies
Not applicable
Author

If you right hand click and go to the sheet properties.. Then layout.. you can set your condition for being able to view the sheet.

Not applicable
Author

Thanks but if I use the sheet properties and then I change the selection by macro it seems tio lose the conditional expression.

For this reason I wan to tom tray to defibne the expression for conditional display by using a Imacro.

I've found this example



set mysheet=ActiveDocument.ActiveSheet
set sp=mysheet.GetProperties
sp.ShowAlways = false
sp.ShowExpression = "sum(Sales)>4000"
mysheet.SetProperties sp

but it don't work in my version.