Sorting of Date??

[priyav24]

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

[tresesco · Accepted solution]

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

[christophebrault]

Hi,

Or simply change sort ordre using expression descending :

max(PurchaseDocDate)

[priyav24]

Thank you Tresesco..

[rbecher]

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