Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

ashissau
Contributor III

[Help] Custom sorting in bar chart not working

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,

1 Solution

Accepted Solutions
trdandamudi
Honored Contributor II

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

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.

 

 

View solution in original post

5 Replies
trdandamudi
Honored Contributor II

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

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

ashissau
Contributor III

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

Hi ,

Thank you for your quick reply . 

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

trdandamudi
Honored Contributor II

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

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.

 

 

View solution in original post

ashissau
Contributor III

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

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
Honored Contributor II

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

Sorry, I am not familiar with Qliksense.