Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I found this solution in another discussion but it's not working for me.
I have 3 Rating values, High, Medium and Low. I want to sort them in that order.
I am using a list box with the Sort by Expression checked and the following expression:
=match(Rating,'High','Medium','Low')
If I sort either by Ascending or Descending I do not get the correct order. (Asending is Low, High, Medium and Descending is Medium, High, Low).
No other sort option is checked.
Qlikview 11.0 if that makes a difference.
Thank you!
-JC
Hi JC,
I have a tutorial on different ways to use Match() on my blog. Here is the link:
If possible, please post the sample QVW App and I can take a look at your application.
Good luck!
Cheers,
DV
I think the best approach in this case is to use Dual() function in your script. This way you have a numerical and a text value for every rate, and it will be ordered by number.
Example: Dual('high', 1) as rating
Dual('medium', 2)
Etc.
Sent from mobile.
Hi JC,
I have a tutorial on different ways to use Match() on my blog. Here is the link:
If possible, please post the sample QVW App and I can take a look at your application.
Good luck!
Cheers,
DV
Thank you, that was a good video! I actually tried both the Dual methods and Match, and Match was much easier. I used Match(Rating,'Low','Medium','High") and sorted Descending and it worked.