Column fixing

[#1]

Hi, is it possible to fix the width of columns (e.g. in the Table Box or in a Pivot Table)?

Thanks a lot

Alex

[manideep78]

It is not possible to fix the width of the column.

But you can fit the data into column by doing this...

Right click on table-> fit columns to data

[#3]

thanks for that, but if I right click on the tables, "fit columns to data" appears only in light grey, so its not choosable.

[manideep78]

Hi

May I know what version of QlikView you are working with?

Right click on Caption of the table then you can see fit columns to data option under properties and also Equal Column Width under fit columns to data option.

[devans_1]

You can change columns in a macro (pos.width is the one for changing the width... ) :

set obj = ActiveDocument.GetSheetObject ("<sheetobjname>")

pos.objGetRect

pos.top = 80

pos.left = 180

pos.width = 800

pos.height=400

obj.SetRect pos

[#6]

its Version 10.00.9519.9 SR 5

and both options (fit... and equal...) are highlighted grey...

[#7]

thanks, but whats exactly the sheetobjname if SheetID=SH12 and ObjectID=TB02?

and does that fix the column or just change?

[devans_1]

It's the Object ID - TB02. So use:

set obj = ActiveDocument.GetSheetObject ("TB02")

[tabletuner]

Probably solved already but the trick is to autorise the developer to move and size objects in the security tab of the worksheet properties.