Qaurter-Year Sorting (Ex: Q1-2019) in Qlik Sense

[piyush_s11]

Hi,

I have a field named Quarter where the field contains values for Quarter as below

Q1-2019

Q2-2019

Q3-2019

Q1-2018

Q2-2018

Q3-2018

Now I want to quarters to be sorted as from latest to oldest as below

Q3-2019

Q2-2019

Q1-2019

Q3-2018

Q2-2018

Kindly help in this issue.

[tresesco · Accepted solution]

Sort by expression: 

=Date#(Quarter,'QM-YYYY')

[piyush_s11]

Thanks  Tresesco,

it worked.. thank you so much 😀