topic Sorting dates on a concatenated dimension. in QlikView

Sorting dates on a concatenated dimension.

shinnickr — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Sorting dates on a concatenated dimension.

jpenuliar — Wed, 22 Nov 2017 15:10:54 GMT

try using MonthName() instead of concat.

MonthName([Discharge Date])

Re: Sorting dates on a concatenated dimension.

jpenuliar — Wed, 22 Nov 2017 15:11:58 GMT

Qlik Help has this fully covered:

monthname - script and chart function ‒ Qlik Sense

Re: Sorting dates on a concatenated dimension.

shinnickr — Wed, 22 Nov 2017 15:19:16 GMT

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

Thank you very much!!