[Help] Custom sorting in bar chart not working

[ashis]

Hi,

I have a bar chart and i want to sort the dimension in the following order. 

1 -'GLOBAL FOREX'

2- 'GLOBAL RATES'

3- 'GLOBAL CREDIT - CORE' 

4 - 'GLOBAL EQUITIES',

5 - 'BSM'

So in the sort tab i am writing this below expression 

=Match([Dimension 1],'GLOBAL FOREX', 'GLOBAL RATES', 'GLOBAL CREDIT - CORE', 'GLOBAL EQUITIES', 'BSM', 'Others')

In the result set i am getting 'Others' in 2nd position. See the attached image.

Please let me know what mistake i am doing here.

Thank you,

[trdandamudi]

Use PICK() function along with Match function. Something like below:

=Pick(Match([Dimension 1],'GLOBAL FOREX', 'GLOBAL RATES', 'GLOBAL CREDIT - CORE', 'GLOBAL EQUITIES', 'BSM', 'Others'),1,2,3,4,5,6)

Hope this helps..

[ashis]

Hi ,

Thank you for your quick reply . 

I tried your solution , but it did not work , getting same result.

[trdandamudi · Accepted solution]

It might have been helpful if you had attached a small sample and show us what is not working. Any have attached is the sample qvw file. The expression is working  and hoping this is what you want.

[ashis]

Hi ,

Thank you very much for the attached QVW. My actual app is in qliksense. It should work in QlikSense as well. however

it is not liking it.

Thank you for your help though.

[trdandamudi]

Sorry, I am not familiar with Qliksense.