topic Re: Sorting of Date?? in QlikView

Sorting of Date??

priyav24 — Mon, 02 Sep 2013 13:12:26 GMT

Hello Everybody,

I have an issue with sorting of Month-Year in a Bar-chart.The Client Requirement is they want the month & year in one field as X-axis in the descending order Like "2013-Sep,2013-Aug.................................2001-Jan".Am unable to sort this Issue..

I have attached the qlikview file for Reference..

Thanks in Advance,

Priya

Re: Sorting of Date??

tresB — Mon, 02 Sep 2013 13:20:45 GMT

Hello Priya,

Your moth year data is not a real date, that is why you are facing the issue.

Change you dimension as calculated dimension, expression: =MonthName(Date#(PurchaseDate_MonthYear,'MMM-YYYY'))

and then change the sort order as numeric(descending)

PFA

Re: Sorting of Date??

christophebrault — Mon, 02 Sep 2013 13:21:53 GMT

Hi,

Or simply change sort ordre using expression descending :

max(PurchaseDocDate)

Re: Sorting of Date??

priyav24 — Mon, 02 Sep 2013 13:23:41 GMT

Thank you Tresesco..

Re: Sorting of Date??

rbecher — Mon, 02 Sep 2013 13:25:37 GMT

It would be better to have MonthName as an additional field..