1 Reply Latest reply: Sep 24, 2012 10:55 AM by frank crezee RSS

    Column Width 2 pivot tables

    Helen Pippard

      Hello

       

      I wish to get the column width of 2 pivot tables which are placed very close next to each other to have the exact same width for each column

       

      How do I know the exact column width of every cell in both pivots

       

      Kind Regards

      Helen

        • Re: Column Width 2 pivot tables

          Hi Helen,

           

          You can use a macro to set the width of a column (somehow there is no normal function in qlikview to do that).

           

          Below an example of the code:

          Sub breedte

          set chart = ActiveDocument.GetSheetObject("CH362")

             

          set p = chart.GetProperties

          set expr = p.Expressions.Item(0).Item(0).Data.ExpressionVisual

          expr.ColWidth = 50

          chart.SetProperties p

          set expr = p.Expressions.Item(1).Item(0).Data.ExpressionVisual

          expr.ColWidth = 400

          chart.SetProperties p

          set expr = p.Expressions.Item(2).Item(0).Data.ExpressionVisual

          expr.ColWidth = 400

          chart.SetProperties p

           

           

          end sub

           

          Hope this helps.

           

          gr.

          Frank