topic Re: How can I sort the MonthYear Chart ? in QlikView https://community.qlik.com/t5/QlikView/How-can-I-sort-the-MonthYear-Chart/m-p/810324#M286054 <HTML><HEAD></HEAD><BODY><P>Thanks guys!</P></BODY></HTML> Tue, 03 Feb 2015 12:10:33 GMT suzel404 2015-02-03T12:10:33Z How can I sort the MonthYear Chart ? https://community.qlik.com/t5/QlikView/How-can-I-sort-the-MonthYear-Chart/m-p/810321#M286051 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I create a chart with 12 Rolling Average Months but I cannot <STRONG>sort</STRONG> MonthYear by ASC.</P><P></P><P>Thank for your help.</P></BODY></HTML> Mon, 02 Feb 2015 18:17:43 GMT https://community.qlik.com/t5/QlikView/How-can-I-sort-the-MonthYear-Chart/m-p/810321#M286051 suzel404 2015-02-02T18:17:43Z Re: How can I sort the MonthYear Chart ? https://community.qlik.com/t5/QlikView/How-can-I-sort-the-MonthYear-Chart/m-p/810322#M286052 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/qlik-blogpost/2622">Get the Dates Right</A></P><P></P><P>Maybe this helps</P><P></P><P>Regards</P><P></P><P>Marco</P></BODY></HTML> Mon, 02 Feb 2015 19:02:45 GMT https://community.qlik.com/t5/QlikView/How-can-I-sort-the-MonthYear-Chart/m-p/810322#M286052 MarcoWedel 2015-02-02T19:02:45Z Re: How can I sort the MonthYear Chart ? https://community.qlik.com/t5/QlikView/How-can-I-sort-the-MonthYear-Chart/m-p/810323#M286053 <HTML><HEAD></HEAD><BODY><P>What Marco is trying to say, is - your Month-Year dimension is a string, not a Date field, and therefore it can't be sorted properly.</P><P></P><P>The most commonly used formula for calculating Month-Year is this:</P><P></P><P>Date(MonthStart(Date), 'MMM-YYYY') as MonthYear.</P><P></P><P>This is typically done within the MasterCalendar load.</P><P></P><P>cheers,</P><P></P><P><STRONG>Oleg Troyansky</STRONG></P><P>Check out my book <STRONG>QlikView Your Business</STRONG> - now available to pre-order on Amazon!</P></BODY></HTML> Mon, 02 Feb 2015 22:46:05 GMT https://community.qlik.com/t5/QlikView/How-can-I-sort-the-MonthYear-Chart/m-p/810323#M286053 Oleg_Troyansky 2015-02-02T22:46:05Z Re: How can I sort the MonthYear Chart ? https://community.qlik.com/t5/QlikView/How-can-I-sort-the-MonthYear-Chart/m-p/810324#M286054 <HTML><HEAD></HEAD><BODY><P>Thanks guys!</P></BODY></HTML> Tue, 03 Feb 2015 12:10:33 GMT https://community.qlik.com/t5/QlikView/How-can-I-sort-the-MonthYear-Chart/m-p/810324#M286054 suzel404 2015-02-03T12:10:33Z Re: How can I sort the MonthYear Chart ? https://community.qlik.com/t5/QlikView/How-can-I-sort-the-MonthYear-Chart/m-p/810325#M286055 <HTML><HEAD></HEAD><BODY><P>You're welcome</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Tue, 03 Feb 2015 14:09:05 GMT https://community.qlik.com/t5/QlikView/How-can-I-sort-the-MonthYear-Chart/m-p/810325#M286055 MarcoWedel 2015-02-03T14:09:05Z