Hi, is it possible to fix the width of columns (e.g. in the Table Box or in a Pivot Table)?
Thanks a lot
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
thanks for that, but if I right click on the tables, "fit columns to data" appears only in light grey, so its not choosable.
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.
You can change columns in a macro (pos.width is the one for changing the width... ) :
set obj = ActiveDocument.GetSheetObject ("<sheetobjname>")
pos.top = 80
pos.left = 180
pos.width = 800
thanks, but whats exactly the sheetobjname if SheetID=SH12 and ObjectID=TB02?
and does that fix the column or just change?
It's the Object ID - TB02. So use:
set obj = ActiveDocument.GetSheetObject ("TB02")
Probably solved already but the trick is to autorise the developer to move and size objects in the security tab of the worksheet properties.
its Version 10.00.9519.9 SR 5
and both options (fit... and equal...) are highlighted grey...
Retrieving data ...