Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
New-Qlik
Creator III
Creator III

Custom Sort

Hello Everyone ,

I want to implement custom sort on country. i have already tried below two approaches

1. Sort expression match(Country, 'Sweden', 'Denmark', 'Norway', 'Others')

2. in Script creating n inline table 

CountrySort:
MAPPING Load * inline [
"Country " , Sort
Denmark,2
Sweden,1
Norwary,3
Other,4
];

Dual("Country ",Applymap('CountrySort',"Country ")) as "Country"

 

both gives me wrong order.

Any suggestions 

10 Replies
New-Qlik
Creator III
Creator III
Author

Actually it worked when i unchecked all sort options even expression