Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Column fixing

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

8 Replies
manideep78
Partner - Specialist
Partner - Specialist

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

Not applicable
Author

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
Partner - Specialist
Partner - Specialist

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
Creator
Creator

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

Not applicable
Author

its Version 10.00.9519.9 SR 5

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

Not applicable
Author

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

and does that fix the column or just change?

devans_1
Creator
Creator

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

set obj = ActiveDocument.GetSheetObject ("TB02")

tabletuner
Creator III
Creator III

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