Discussion board where members can get started with QlikView.
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.
Go to 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.
View solution in original post
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..
Thank you for your quick reply .
I tried your solution , but it did not work , getting same result.
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.
Sorry, I am not familiar with Qliksense.