topic Re: Sorting not working in QlikView

Sorting not working

Fri, 25 Jan 2013 14:51:14 GMT

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

Re: Sorting not working

Fri, 25 Jan 2013 14:57:31 GMT

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.

Re: Sorting not working

IAMDV — Fri, 25 Jan 2013 15:06:22 GMT

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,

www.QlikShare.com

Re: Sorting not working

Fri, 25 Jan 2013 16:08:46 GMT

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.

Re: Sorting not working

IAMDV — Fri, 25 Jan 2013 16:23:53 GMT

Thank you JC. Appreciate your comments

Cheers,

www.QlikShare.com