Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
ashis
Creator III
Creator 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
Master II
Master II

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
Master II
Master II

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
Creator III
Creator III
Author

Hi ,

Thank you for your quick reply . 

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

trdandamudi
Master II
Master II

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

ashis
Creator III
Creator III
Author

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
Master II
Master II

Sorry, I am not familiar with Qliksense.