Quarter display and sorting

[Buliano]

I need to display data per quarter in a Bar chart, sorted by quarter, and my quarters start in February.

The following dimension does it ok, and with correct sorting, but with a small issue:

QuarterName(QuarterlyReportDate,0,2)

The small issue is that the quarter starting in November is displayed as:

Nov-Jan 2022

While in fact it would be more clear if it was like:

Nov 2022- Jan 2023

As an alternative, I am trying to use MonthName. This solves the issue, but creates one with the sorting:

MonthName(QuarterStart(QuarterlyReportDate,0,2)) & ' - ' & MonthName(QuarterEnd(QuarterlyReportDate,0,2))

In any quarter, the year is displayed for both months.

With just the first bit, sorting is correct: MonthName(QuarterStart(QuarterlyReportDate,0,2))

However, concatenating MonthName with something else makes Qlik unable to sort the quarters correctly. At least I can’t find a way to do so.

Any help on how I could have the quarters correctly sorted and at the same time display the two years (at least for the quarter which is between two years)?

Thanks in advance

[vinieme12 · Accepted solution]

Create a dual value field as below

DUAL( MonthName(QuarterStart(QuarterlyReportDate,0,2)) & ' - ' & MonthName(QuarterEnd(QuarterlyReportDate,0,2)) , floor(QuarterStart(QuarterlyReportDate,0,2)) ) as YourfieldName