How to sort by a Date field

[#1]

Hi,

PFA the data I have in a Qlikview straight through table.  Here the quarter field was derived from the period_start_dt field.  The ordering I am expecting is as follows:

1Q2015

3Q2014

2Q2014

1Q2014

Please assist.

Thanks,

Sudha.

[Gysbert_Wassenaar]

You can use the Dual function to create a numeric value with different display format. See attached example.

[maxgro]

or sort by expression desc

Mid(Quarter,3,4) & Left(Quarter,1)