topic Formatting the column width of a straight table in QlikView

Formatting the column width of a straight table

Tue, 09 Oct 2012 18:32:12 GMT

When creating a straight table, is it possible to manually set the size of each of the columns? I know that it’s possible to manually set the X and Y position as well as the height and width of the overall object but I need to manually set the width of each column. I have multiple straight tables in my document and I am positioning them so they all look like one table together.

Any help would be much appreciated.

Re: Formatting the column width of a straight table

Gysbert_Wassenaar — Tue, 09 Oct 2012 18:37:56 GMT

You can change the column width with the mouse. If you hover on the right side of the column the mouse cursor will change to a double headed arrow. If you left click and keep the button down you can resize the column. Unfortunately there's is no way to set the column with for several columns at the same time afaik.

Re: Formatting the column width of a straight table

Tue, 09 Oct 2012 18:54:30 GMT

I’m aware that it’s possible to change the column width by using the mouse. What I’m asking is whether it’s possible to specify the width of each column, similar to the way you can do this by going to Properties -> Caption and then set the width for the entire table. I have 5 straight tables and I have them positioned vertically on the sheet. The intention is to make the 5 individual straight tables look like one table which is why I am trying to manually set the column width.

Re: Formatting the column width of a straight table

Gysbert_Wassenaar — Tue, 09 Oct 2012 18:59:18 GMT

No, that's not possible. Maybe it can be done with a macro, but I haven't found where yet and I doubt it is possible at all.

edit: I did find something:

rem ** Double column width of column 2 in pivot table CH01 **

set chart = ActiveDocument.GetSheetObject("CH01")

pwidths = chart.GetPixWidths(1,1).PixWidths

chart.SetPixWidth 1, pwidths(0)*2

So there is a way doing it with some code.

Re: Formatting the column width of a straight table

Tue, 09 Oct 2012 19:16:32 GMT

Thanks. I'll give it a try.

Re: Formatting the column width of a straight table

Anonymous — Thu, 28 Mar 2013 14:08:51 GMT

Thank you. This works very well.

Where can I find the properties for GetPixWidths to find out what the (1,1) refers to? I've managed to make it do exactly what I want by just playing around, but it would be good to see this along with other available functions.

Joao

Re: Formatting the column width of a straight table

Wed, 11 Dec 2013 13:38:35 GMT

Hi Gysbert,

I am also in the same situation where I want to set width of all columns from one place. I am wondering where to add the script block you have specified.

Re: Formatting the column width of a straight table

Sun, 04 Dec 2016 14:52:05 GMT

Hi ,

I develop this macro to help me to define the with of my straight table or any other graph. i hop eit help you.

sub Width

set chart = ActiveDocument.GetSheetObject("CH03")

set cp = chart.GetProperties

set dims = cp.Dimensions

dims(0).ColWidth = 10 'mettre ici la largeur souhaitée

chart.SetProperties cp

set expr = cp.Expressions.Item(0).Item(0).Data.ExpressionVisual

expr.ColWidth = 200

chart.SetProperties cp

set expr = cp.Expressions.Item(1).Item(0).Data.ExpressionVisual

expr.ColWidth = 200

chart.SetProperties cp

set expr = cp.Expressions.Item(2).Item(0).Data.ExpressionVisual

expr.ColWidth = 200

chart.SetProperties cp

end sub

Re: Formatting the column width of a straight table

Anonymous — Sun, 05 Feb 2017 06:49:19 GMT

Hi Ejmal,

This seems interesting.

I am new to Qlik, How do I use the macro in a .qvf?

Re: Formatting the column width of a straight table

Mon, 03 Jul 2017 19:22:43 GMT

Where in Qlik Sense would I enter this code?

Re: Formatting the column width of a straight table

qvqfqlik — Thu, 19 Oct 2017 15:39:23 GMT

after adding the table and columns , click done and try to adjust the column width as you need.. and then again click edit and click 'apply'

this will give the fixed column width.

Re: Formatting the column width of a straight table

Fri, 20 Oct 2017 09:47:39 GMT

That's fine thanks, I have dropped Qlik and have switched to PowerBI, seems to be much better than Qlik, I have managed to do much more with PowerBI as it is friendlier, faster and seems to be a more settled product with all the features and then some.
The great part is that it is also a lot more cost effective. Anyway

Thanks anyway

Re: Formatting the column width of a straight table

Jayasharma89 — Thu, 06 Jun 2019 05:55:42 GMT

Hi ,

Could please any one help how can i achieved this format of table.

Thanks For Help.