topic Re: putting in date order in QlikView https://community.qlik.com/t5/QlikView/putting-in-date-order/m-p/513988#M1130753 <HTML><HEAD></HEAD><BODY><P><STRONG>Chris</STRONG></P><P></P><P>How about converting them to QlikView date format ?</P><P></P><P>Then everything will be easier for you.</P><P></P><P></P><P>Best Regards,&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>Bill</STRONG></P></BODY></HTML> Tue, 12 Nov 2013 15:49:26 GMT Anonymous 2013-11-12T15:49:26Z putting in date order https://community.qlik.com/t5/QlikView/putting-in-date-order/m-p/513987#M1130752 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Any quick way of ensuring on a graph data is orted in month order? None of the normal sorting options (frequency, load order) enable it to show this way.</P><P></P><P>Months are text and not in date format.</P><P></P><P></P><P>Cheers</P><P></P><P></P><P>Chris</P></BODY></HTML> Tue, 12 Nov 2013 15:47:15 GMT https://community.qlik.com/t5/QlikView/putting-in-date-order/m-p/513987#M1130752 2013-11-12T15:47:15Z Re: putting in date order https://community.qlik.com/t5/QlikView/putting-in-date-order/m-p/513988#M1130753 <HTML><HEAD></HEAD><BODY><P><STRONG>Chris</STRONG></P><P></P><P>How about converting them to QlikView date format ?</P><P></P><P>Then everything will be easier for you.</P><P></P><P></P><P>Best Regards,&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>Bill</STRONG></P></BODY></HTML> Tue, 12 Nov 2013 15:49:26 GMT https://community.qlik.com/t5/QlikView/putting-in-date-order/m-p/513988#M1130753 Anonymous 2013-11-12T15:49:26Z Re: putting in date order https://community.qlik.com/t5/QlikView/putting-in-date-order/m-p/513989#M1130754 <HTML><HEAD></HEAD><BODY><P>Load an Inline table with MonthID and MonthName like</P><P>MonthID&nbsp;&nbsp;&nbsp;&nbsp; MonthName</P><P>&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Jan</P><P>&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Feb</P><P>&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Mar</P><P>....</P><P></P><P>make sure MonthName and the other field joins and then sort it by MonthID</P></BODY></HTML> Tue, 12 Nov 2013 15:50:02 GMT https://community.qlik.com/t5/QlikView/putting-in-date-order/m-p/513989#M1130754 2013-11-12T15:50:02Z Re: putting in date order https://community.qlik.com/t5/QlikView/putting-in-date-order/m-p/513990#M1130755 <HTML><HEAD></HEAD><BODY><P>You can use this expression into your Sort Tab</P><P></P><P>Match(yourfield,'jan','fev','mar','abr','mai','jun','jul','ago','set','out','nov','dez')</P></BODY></HTML> Tue, 12 Nov 2013 15:53:29 GMT https://community.qlik.com/t5/QlikView/putting-in-date-order/m-p/513990#M1130755 Clever_Anjos 2013-11-12T15:53:29Z