topic Re: Pivot table column width. in QlikView

Pivot table column width.

infosense_devel — Thu, 11 May 2017 09:13:59 GMT

Hello All,

i have pivot table same as below.

where if i increase size of Expression Labels then the Column width is also getting increased automatically.

i need expression label same size but want to decrease width of Columns.

thanks in advance.

Re: Pivot table column width.

Anil_Babu_Samineni — Thu, 11 May 2017 11:08:19 GMT

1) For fit the column may be Right Click and use Fit Columns To Data.

2) What expression you are expecting?

Re: Pivot table column width.

el_aprendiz111 — Thu, 11 May 2017 14:16:01 GMT

Hi,

Macro:

sub AutoFit

set chart = ActiveDocument.GetSheetObject("CH13")

chart.SetPixWidth 0,100

chart.SetPixWidth 1,100

chart.SetPixWidth 2,100

chart.SetPixWidth 3,100

chart.SetPixWidth 4,100

end sub

Re: Pivot table column width.

infosense_devel — Fri, 12 May 2017 10:33:11 GMT

Thanks You for Replay, But I have transformed pivot table to straight table to get it Done.

Re: Pivot table column width.

Anil_Babu_Samineni — Fri, 12 May 2017 12:10:40 GMT

Then close this thread by flag of correct answer of your Response

Re: Pivot table column width.

ElizaF — Fri, 12 May 2017 14:15:53 GMT

I know it is closed this thread, but I faced with same problem .

The solution is to create another dimension (dummy dimension, moved on vertically) and after you can change the width of the Columns.

It is a QlikView tricks . Try it.

Re: Pivot table column width.

jessica_webb — Thu, 13 Jul 2017 08:20:42 GMT

Hi Eliza,

I've tried your trick but can't get it to work.

I have two dimensions - one vertical with the expression label to the right, and one horizontal with the expression value beneath.

I've added a dummy dimension, but still, my expression label cells and expression value cells change size with each other.

Any ideas what I'm doing wrong?

Thanks,
Jess

Re: Pivot table column width.

qlikviewforum — Tue, 16 Jul 2019 12:44:27 GMT

Hi Elisa and all,

Anyone got any solution while using pivot table? Please share the solution if you have find any.

Re: Pivot table column width.

Yakushi — Thu, 25 Jul 2019 14:18:05 GMT

Hello,

didn't find a solution using the pivot table, but you can replace it with a straight table and check the Horizontale box in the Presentation tab.

Regards.

Re: Pivot table column width.

minalux — Wed, 17 Jan 2024 23:46:51 GMT

@Anil_Babu_Samineni If it is not possible to change the column width of the pivot table. Is it possible to have all column fit in the area without having any horizontal scroll?

Re: Pivot table column width.

Anil_Babu_Samineni — Thu, 18 Jan 2024 08:47:35 GMT

@minalux It depends on how the columns adjusted, Because Qlik works based on width of the object.

Re: Pivot table column width.

minalux — Thu, 18 Jan 2024 17:29:54 GMT

Let's say I have this table. Right now, it is showing total of 1 dimension columns and 4 metric columns

The full table has 7 metric columns. If the columns were more narrow, it should logically fit into that space. So how can I restrict the pivot table width to force it to include all columns without needing horizontal scroll bar?