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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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