topic How to sort Date in format YYYY-NameMonth in QlikView

How to sort Date in format YYYY-NameMonth

slondono — Tue, 31 May 2016 15:19:13 GMT

Hi guys,

I have a date as dimension. The format of this date is for example 2015-Jan, 2015-Feb,...,2016-May, etc. But in my charts i cant find a way to order it. I need that be ordered by normal time-line.

Any idea??

(in some graphs the order is ok, but in others no. Dont know why )

Re: How to sort Date in format YYYY-NameMonth

sunny_talwar — Tue, 31 May 2016 15:23:08 GMT

Change your dimension to a calculated dimension:

Date(Date#(Periodo, 'YYYY-MMM'), 'YYYY-MMM')

Re: How to sort Date in format YYYY-NameMonth

Anonymous — Tue, 31 May 2016 15:25:35 GMT

Hi Sebastian,

In order expression, if this Date is text format then use

=Max({1} MakeDate(Subfield(Date,'-',1),Month(Month#(Subfield(Date,'-',1),'MMM'))))

but if your Date is in Date format, then use:

=Max({1} Date)

Thanks!!

Re: How to sort Date in format YYYY-NameMonth

slondono — Tue, 31 May 2016 15:39:03 GMT

Theres no need to change the dimension to a calculated dimension, just put the sentence in the Order by Expression.

So much Thanks

Re: How to sort Date in format YYYY-NameMonth

sunny_talwar — Tue, 31 May 2016 15:40:45 GMT

Yes that is an alternative. I like to let my dimension drive the sort rather than adding an extra expression on sort tab. But yes, that def. works as well