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 ...