topic Re: Column fixing in QlikView

Column fixing

Mon, 25 Feb 2013 14:49:30 GMT

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

Re: Column fixing

manideep78 — Mon, 25 Feb 2013 15:07:11 GMT

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

Re: Column fixing

Mon, 25 Feb 2013 16:14:51 GMT

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

Re: Column fixing

manideep78 — Tue, 26 Feb 2013 10:56:02 GMT

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.

Re: Column fixing

devans_1 — Tue, 26 Feb 2013 11:27:51 GMT

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

Re: Column fixing

Tue, 26 Feb 2013 13:19:04 GMT

its Version 10.00.9519.9 SR 5

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

Re: Column fixing

Tue, 26 Feb 2013 13:30:42 GMT

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

and does that fix the column or just change?

Re: Column fixing

devans_1 — Tue, 26 Feb 2013 13:46:18 GMT

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

set obj = ActiveDocument.GetSheetObject ("TB02")

Re: Column fixing

tabletuner — Wed, 02 Oct 2013 08:14:46 GMT

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