Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner - Master II
Partner - Master II

write custom sorting expression

Hello
can someone help me write an expression for sorting in a bar chart
I have 2 dimensions one is string other is numeric
I'm sorting first on the string dimension as follows to have a custom sorting:
Match
(
Only({1} [BUSINESS_UNIT_DESC]),
'Canada','Latin America','United States'
,'BU1','BU2','BU3','BU4','BU5','AM',
'Central Europe','France Benelux','MEA','Nordics Russia','Southern Europe + Morocco','UKI','Total'
)

what I want now to write something here to sort the other numeric dimension desc

I can walk on water when it freezes
Labels (1)
1 Reply
BrunPierre
Partner - Master
Partner - Master

Have you tried performing a custom sort yet?

BrunPierre_0-1680686218291.png