Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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