0 Replies Latest reply: May 26, 2011 12:27 PM by chevalierbip RSS

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