Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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