0 Replies Latest reply: Mar 16, 2015 7:52 PM by Thomas Klingenbrunn RSS

    Expand dimension in a pivot table using macro in Qlikview 11

      Hi,

       

      I would like to create a macro to expand or collapse a specific dimension in a pivot table. I noticed others questioned this as well but did not see an answer for Qlikview 11. Apparently in Qlikview 8 it could be done the following way:

       

      sub CollapsePivot

      set chart = ActiveDocument.GetSheetObject("CH01")
      chart.CollapseLeft 0,0,true
      end sub

       

      Is there an equivalent in Qlikview 11?

       

      Thanks

      -Thomas