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: 
Not applicable

Coloumn width of Transposed Pivot table

Hi ALL,

I changed existing two dimensions as columns and expressions as rows in a pivot table by using drag option. The expressions label width require more .Now the Expression labels are in First column of changed pivot table.The other columns have data require less width.

How to make different column widths like a original pivot table?Here I require more width for the First column(Expression Labels).

Thankyou

1 Solution

Accepted Solutions
nathanfurby
Specialist
Specialist

If you have 1 dimension then use straight table and select 'Horizontal' option in Presentation tab.

If you need to use a pivot table for some reason then adding a 2nd dimension (even a blank one) will allow you to change the width of the first column without the other columns following suit.

Edit - you will also need to select the 'Indent Mode' from the 'Style' properties tab.

View solution in original post

5 Replies
alexandros17
Partner - Champion III
Partner - Champion III

Unfortunately all expression columns will have the same width ...

Not applicable
Author

Thank you Alessandro

alexandros17
Partner - Champion III
Partner - Champion III

If you want you may mark my answer ...

nathanfurby
Specialist
Specialist

If you have 1 dimension then use straight table and select 'Horizontal' option in Presentation tab.

If you need to use a pivot table for some reason then adding a 2nd dimension (even a blank one) will allow you to change the width of the first column without the other columns following suit.

Edit - you will also need to select the 'Indent Mode' from the 'Style' properties tab.

qlikviewforum
Creator II
Creator II

I have only one dimension which is month which transposed horizontally and measures are transposed vertically, so i am unable to change the width of dimension and measure separately. 

Can you please help me out on this.