topic Re: fit column to data in QlikView

fit column to data

Thu, 08 Aug 2013 10:48:20 GMT

Hi to Everybody,

I would like write a macro to fit colum to data.

I wrote:

sub fitColumn

set obj = ActiveDocument.GetSheetObject("CH157")

set cp = obj.GetProperties

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

expr.ColWidth = 800

obj.SetProperties cp

end sub

but it doesn'work

What's the problem?

Thanks in advance

Re: fit column to data

marcus_sommer — Thu, 08 Aug 2013 11:25:20 GMT

See here:

http://community.qlik.com/message/374465#374465

- Marcus

Re: fit column to data

Thu, 08 Aug 2013 11:25:40 GMT

I have to fit column width no the window zoom

Re: fit column to data

Thu, 08 Aug 2013 11:41:27 GMT

I have a Pivot table, the code:

chart.SetPixWidths 0,w

chart.EqualPixWidths 1

doesn't work

Thank you

Re: fit column to data

er_mohit — Thu, 08 Aug 2013 11:42:42 GMT

try this

sub x

set chart = ActiveDocument.GetSheetObject("CH02")

chart.SetPixWidth 0,100

chart.SetPixWidth 1,100

chart.SetPixWidth 2, 0

end sub

Re: fit column to data

cmano — Fri, 05 Aug 2022 09:44:11 GMT

Hello Er

For reference i have a pivot table with 2 columns.

I use at edit module the below macro as you post :

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.