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: 
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 II
Partner - Master II

Have you tried performing a custom sort yet?

BrunPierre_0-1680686218291.png