Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
infosense_devel
Creator II
Creator II

Pivot table column width.

Hello All,

i have pivot table same as below.

table1.png

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.

1 Solution

Accepted Solutions
infosense_devel
Creator II
Creator II
Author

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

View solution in original post

11 Replies
Anil_Babu_Samineni

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

2) What expression you are expecting?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
el_aprendiz111
Specialist
Specialist

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
Creator II
Creator II
Author

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
ElizaF
Creator II
Creator II

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
Creator III
Creator III

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
Creator II
Creator II

Hi Elisa and all,

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

Yakushi
Partner - Contributor
Partner - Contributor

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
Contributor II
Contributor II

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