Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
qlik_venu
Creator
Creator

Pivot table

Hi,

We have a pivot table which consist of the dimension in the rows and the measures in the columns similar to this,

Sales Profit Loss

Customer A 10 5 2

Customer B 15 10 3

We would want this to appear as below, the measures should appear as rows and the dimension country should appear in the columns list.

Customer A Customer B

Sales 10 15

Profit 5 10

Loss 2 3

Thanks,

Venu

1 Reply
qlik_venu
Creator
Creator
Author

I was able to do this by dragging the country dimension and with blue arrow was able to swap the columns and the rows.