Discussion board where members can get started with QlikView.
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:
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.
Go to Solution.
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.
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
Sent from mobile.
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.
Thank you JC. Appreciate your comments