Pivot table column width.

[infosense_devel]

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.

[Anil_Babu_Samineni]

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

2) What expression you are expecting?

[el_aprendiz111]

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

[infosense_devel · Accepted solution]

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

[Anil_Babu_Samineni]

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

[ElizaF]

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.

[jessica_webb]

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

[qlikviewforum]

Hi Elisa and all,

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

[Yakushi]

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.

[minalux]

@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?