
Contributor III
2024-06-18
01:59 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sorting Quarter - Year on Qlik sense
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!
295 Views
1 Reply

Partner - Master
2024-06-18
03:20 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You could try something like Num(Right("Quarter-Year, 2) & left("Quarter-Year", 1)) to sort by expression in ascending order.
264 Views
