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: 
dmxmikey
Creator
Creator

how do i get dimension in column rather than row format?

I need to get the cust code next to the customer

Cust code          Customer

2469                    Mr & Mrs

2480                    Donald

1 Solution

Accepted Solutions
Peter_Cammaert
Partner - Champion III
Partner - Champion III

In a pivot table, just grab each dimension and expression header until the cursor changes into a blue arrow, and drag the arrow to the other side. In this way, you can turn expression into rows, and dimensions into columns.

Option "Allow Pivoting" must be checked in Object Properties->Presentation

Peter

View solution in original post

7 Replies
alexandros17
Partner - Champion III
Partner - Champion III

IN presentation tab of your chart there is a check box "Horizontal" check it and let me know

dmxmikey
Creator
Creator
Author

Don’t seem to have that option

Delivering the best in Foodservice...

Not applicable

Hi, this option is present in straight table not in pivot chart.

Peter_Cammaert
Partner - Champion III
Partner - Champion III

In a pivot table, just grab each dimension and expression header until the cursor changes into a blue arrow, and drag the arrow to the other side. In this way, you can turn expression into rows, and dimensions into columns.

Option "Allow Pivoting" must be checked in Object Properties->Presentation

Peter

jpenuliar
Partner - Specialist III
Partner - Specialist III

Agree

Not applicable

Hi,

Create straight table and you will get this option in presentation tab.

dmxmikey
Creator
Creator
Author

Thank you all for your help