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

Disable a dimension with a macro in a pivot table

Hello,

I wish I could disable or enable a dimension in a PivotTable with a macro.

The fact of creating a calculated dimension in the object if (wvariable = 1, dimension1, Dimension2) works very well.
But when the calculated dimension uses fields grouped (hierarchic or cyclic), QlikView no longer identifies the properties of the scale (cycle and hierarchy).

So i search a new way.

For example, i use this for the expressions and it works well.

set wExpr0 = WGETPROP.Expressions.Item(0).Item(0).Data.ExpressionData

Thank you

wExpr0.Enable = false

Have you a solution in a macro for the expressions ...

0 Replies