topic Re: [Help] Custom sorting in bar chart not working in QlikView

[Help] Custom sorting in bar chart not working

ashis — Wed, 25 Nov 2020 16:16:04 GMT

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,

Re: [Help] Custom sorting in bar chart not working

trdandamudi — Sun, 04 Aug 2019 12:13:57 GMT

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..

Re: [Help] Custom sorting in bar chart not working

ashis — Sun, 04 Aug 2019 14:03:14 GMT

Hi ,

Thank you for your quick reply .

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

Re: [Help] Custom sorting in bar chart not working

trdandamudi — Sun, 04 Aug 2019 16:33:00 GMT

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.

Re: [Help] Custom sorting in bar chart not working

ashis — Mon, 05 Aug 2019 05:44:15 GMT

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.

Re: [Help] Custom sorting in bar chart not working

trdandamudi — Mon, 05 Aug 2019 16:48:36 GMT

Sorry, I am not familiar with Qliksense.