Sorting not working

[#1]

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

[#2]

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.

[IAMDV · Accepted solution]

Hi JC,

I have a tutorial on different ways to use Match() on my blog. Here is the link:

http://qlikshare.com/292

If possible, please post the sample QVW App and I can take a look at your application.

Good luck!

Cheers,

DV

www.QlikShare.com

[#4]

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.

[IAMDV]

Thank you JC. Appreciate your comments

Cheers,

DV

www.QlikShare.com