Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner - Master II
Partner - Master II

Bar chart sorting by expression

Hello
got a barchart with two dimensions : Fiscal Year, and Region
in this barchart  I'm displaying the total by the above dimesions plus the values 
so the Region dimension is calculated dimension as follows: pick(Total,Region, 'Total')
Total is a dimension I created in the script from an inline table with two values 1, and 2
so far so good

Now I want to sort the result not as acending / descending but custom as follows:
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'
)

 

I'm getting the following result:

ali_hijazi_0-1680589056732.png

but I want the Total to be placed on the far-right
so how can I update the formula of sorting to accoplish this

I can walk on water when it freezes
Labels (2)
0 Replies