Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
SamuelHaag
Contributor III
Contributor III

Pivot table - change order of columns

Hi,

I would like to change the order of the columns in a pivot table. Right now the order is like this with the "Region" dimension:

EuropeEmerging MarketsAsiaNorth America

 

How can I change it to this:

North AmericaEuropeEmerging MarketsAsia

 

I tried to create a sort expression with a match function and another one with the dual function. Both didn't work.

 

Thanks!

 

Regards

 

Samuel

 

Labels (3)
1 Solution

Accepted Solutions
Kirsten
Creator II
Creator II

This one worked for me:

Match([NAME OF DIMENSION IN ROW PIVOTTABLE], Dual('North America',1), Dual('Europe',2), Dual('Emerging Markets',3), Dual('Asia',4))

View solution in original post

2 Replies
Kirsten
Creator II
Creator II

This one worked for me:

Match([NAME OF DIMENSION IN ROW PIVOTTABLE], Dual('North America',1), Dual('Europe',2), Dual('Emerging Markets',3), Dual('Asia',4))

SamuelHaag
Contributor III
Contributor III
Author

Thanks it works! 🙂