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: 
MattMika
Contributor II
Contributor II

Ranking in order of priority

Dear Community, 

 

I have a "Planning" column which is causing duplicates, I need to prioritize the contents of this column which contains A , B and C such that A is stronger then B then C.

For exemple : if Planning contains A, B and C, then Planning take A , if B and C then Planning must take B...

I tried this but it didn't work :

if ( match(Planning,'A') and match ( Planning,'B'),'A',
if ( match(Planning,'A') and match ( Planning,'C'),'A',
if ( match(Planning,'B') and match ( Planning,'C'),'B'))) as Plan

Thanks in advance 

Labels (1)
10 Replies
MattMika
Contributor II
Contributor II
Author

It worked as expected, Thank you for your help ✌️