topic Re: Get Column WIdth in Straight table in QlikView

Get Column WIdth in Straight table

Fri, 05 Jul 2013 08:48:45 GMT

Using macro, how can i get a specific column width (for example, the width of column number 2) in a straight table.

there is a way of doing so in a Pivot table with the GetPixWidths function, but it's not working with a straight table.

Thanks 🙂

Refael

Fri, 05 Jul 2013 09:00:31 GMT

try this in macro

sub example

set chart = ActiveDocument.GetSheetObject("CH01")

SET P = Chart.GetProperties

set expr = P.Expression.Item(0).DataExpressionVisual

expr.ColWidth = 120

chart.SetProperties P

end sub

note-- you can change the colwidth

er_mohit — Fri, 05 Jul 2013 09:07:52 GMT

go to this link

Fri, 05 Jul 2013 09:12:58 GMT

Tnx for your response.

Already tried that, but it's not working for me.

It throws an error in this row: " set expr = P.Expression.Item(0).DataExpressionVisual"

Fri, 05 Jul 2013 09:21:26 GMT

Sub example2

set chart = ActiveDocument.GetSheetObject("CH01")

set p = chart.GetProperties

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

expr.ColWidth = 250

chart.SetProperties p

end sub

Sun, 07 Jul 2013 11:26:15 GMT

Thanks it worked 🙂

but when i try to get the ColWidth it returns a number which is incorrect.

for example, "msgbox(expr.ColWidth)" prints 400 when the actual number is 134

maybe it's in a different format?