Sorting Quarter - Year on Qlik sense

[rajany089]

Hi Qlik Community,

I have created a `Quarter-Year` field using the following formula in my load script:

IF(len(Effective_SLA_Date)>0, 'Q' & ceil(month(Effective_SLA_Date)/3)& '-' &Year(Effective_SLA_Date)) as Effective_SLA_Quarterly,

I now need to sort this `Effective_SLA_Quarterly` field in descending order, such as `Q1-2022`, `Q2-2022`, and so on up to `Q2-2024`.

How can I achieve this sorting in Qlik Sense?

Thank you!

[BrunPierre]

You could try something like Num(Right("Quarter-Year, 2) & left("Quarter-Year", 1)) to sort by expression in ascending order.