Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try using MonthName() instead of concat.
MonthName([Discharge Date])
Qlik Help has this fully covered:
Ah excellent. I tried using MonthName() but still using the concatenation. I didn't try using it just by itself.
Thank you very much!!