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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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