Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

1 Reply
danielrozental
Master II
Master II

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