Sorting by Fiscal Month

[cfountain72]

Hello, 

I'm trying to sort some activity by Fiscal Month (where October is the first month), but am having some issues. I tried sorting it using this expression:

Match(Month(TransferResolutionDate), 10, 11, 12, 1, 2, 3, 4, 5, 6, 7, 8, 9)

But my line chart looks like this. (Apparently, Qlik Sense thinks Feb comes between Dec and Jan.)

The TransferResolutionDate is not relying on a Date Dimension in the data model, so joining should not be an issue, and no selections are being made.

Any suggestions? 

Thanks for your help,

Chris

[BrunPierre]

Like this, perhaps?

Match(Only({1} Month(TransferResolutionDate)),'Oct','Nov','Dec','Jan','Feb'.....)

[cfountain72]

Thanks BrunPierre! That does work. I also was able to use Max instead of Only to get it to work. But I really don't understand why it works for the Month Strings, but not for the Numeric Month values?

[BrunPierre · Accepted solution]

It should work with the month number rather.

Please mark it as a solution to close the thread, thanks.