Sorting dates on a concatenated dimension.

[shinnickr]

Hello,

I am trying to sort dates based on a concatenated dimension.  This is my expression:

=Month([Discharge Date]) & ' ' & Year([Discharge Date])

But when put into a graph, the dates aren't sorted correctly. 

I've tried a wide variety of different sort options, using Dual() (though maybe I wasn't using it correctly), and a few different expressions to attempt to sort this correctly.

Any help would be greatly appreciated!

Thank you

[jpenuliar · Accepted solution]

try using MonthName() instead of concat.

MonthName([Discharge Date])

[jpenuliar]

Qlik Help has this fully covered:

monthname - script and chart function ‒ Qlik Sense

[shinnickr]

Ah excellent.  I tried using MonthName() but still using the concatenation.  I didn't try using it just by itself.

Thank you very much!!