topic Re: Pivot table adjust column in QlikView

Pivot table adjust column

cmano — Fri, 05 Aug 2022 09:42:55 GMT

Hello there.

For reference i have a pivot table with 2 columns.

I use a edit module the below macro :

sub x

set chart = ActiveDocument.GetSheetObject("CH82")

chart.SetPixWidth 0,200
chart.SetPixWidth 0,900

end sub

The problem is that it takes only the wider width and adjust the other...

Any suggestion?

Thank you for your time.

Re: Pivot table adjust column

marcus_sommer — Fri, 05 Aug 2022 15:33:33 GMT

I'm not sure if it's supported respectively documented to adjust the column-width individually with a macro. The best would be to play with the various pix options listed within the APIGuide.qvw and also mixing/extending the provided examples:

Important to note: a individual width is only for different expressions possible and not to a solo expression with n horizontal dimension-values.

- Marcus