topic Auto fit columns to a data in QlikView

Auto fit columns to a data

Thu, 26 Nov 2009 12:14:14 GMT

How can i auto fit columns to a data after expanding columns in pivot tables?[8-)]

Auto fit columns to a data

Thu, 26 Nov 2009 14:24:34 GMT

You do it manually by double clicking on the icon that becomes visible when your cursor moves across the rim of a column.

The settings on the Layout tab of the table/field has a 'Size to Data' checkbox that should do this automatically. It might help to deactivate it, then press Apply and then activate it again.

Auto fit columns to a data

Thu, 26 Nov 2009 14:28:10 GMT

so, does it mean it can not be done automatically?

Auto fit columns to a data

Thu, 26 Nov 2009 14:32:08 GMT

The checkbox option should do that. You probably need the 'Allow Move/Size' activated as well.

As far as I know both options are activated on creation, so it should work from the start (theoratically).

Auto fit columns to a data

Fri, 27 Nov 2009 21:55:25 GMT

Manual - just right click and click "fit columns to data", this will fit all the columns in one go

Automatic - can be done through a macro

regards

peter

Auto fit columns to a data

kji — Fri, 27 Nov 2009 22:13:57 GMT

"Size to data" has nothing to do with column sizing, it only disables the white area outside the table if object it is sized larger then the table.

Re: Auto fit columns to a data

vishwanath — Fri, 06 Mar 2020 10:21:17 GMT

When I selected the option "Fit Column To Data" then the location columns are fitted well but the Data column also squeezed as you can see in the next table.

I tried all of these options in the Layout tab, but unable to figure out.

Please help me out.

Thank you in advance.

Regards,

Vishwanath