4 Replies Latest reply: Jan 25, 2013 11:23 AM by Deepak Vadithala RSS

    Sorting not working

      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