1 Reply Latest reply: Feb 4, 2013 7:56 PM by Daniel Rozental RSS

    Weird sorting problem...

      Hi,

      I have a simple table with "season codes" like S12, S13, W12, W13, etc and I need them to be sorted descending using this expression:

      =right(Season, 2) & left(Season, 1)

      resulting in something like W13, S13, W12, S12 etc

       

      What I get in QV is completely messed up instead...

       

      Please check the QVW attached and let me know if I'm doing something wrong.

       

      Thank you,

      Roberto

        • Re: Weird sorting problem...
          Daniel Rozental

          Using dual you can define a text and number attributes for each field value. That's usually what's done for month jan, feb, mar are actually 1,2,3 and they are always sorte.

           

          That way your seasons will behave like a number and will always be sorted, in every selector or chart.

           

          Please see the attachment