3 Replies Latest reply: Feb 16, 2015 7:55 AM by Marcus Sommer RSS

    Is there any macro available to hide first column expression of every pivot char

      Hi Friends,


      I am new to Qlikiview macros. I want to hide every first column of every pivot chart on the dash board. So that I can use along with

      Pick(Dimentionality,1,2,3,4....etc) to sort the last expression always.


      I got one Macro from one of our friends.


      public sub MyHide
            call HideColumn("CH26",5)
      end sub


      private sub HideColumn(ch,n)
        set ch = ActiveDocument.GetSheetObject(ch)
        ch.SetPixWidth (n), 50
      end sub


      Can I tweak this macro to to apply to every pivot chat I use....