Disable a dimension with a macro in a pivot table

Thu, 26 May 2011 16:27:39 GMT

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

topic Disable a dimension with a macro in a pivot table in QlikView

Disable a dimension with a macro in a pivot table