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

       

       

      Thanks