topic Expression to sort chart by two expressions in QlikView https://community.qlik.com/t5/QlikView/Expression-to-sort-chart-by-two-expressions/m-p/823963#M536013 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a dimension comprised of two fields - Month and Year (=%Month&amp;' - '&amp;%Year).</P><P></P><P>I want to sort my chart so that the order is chronological (Nov-13, Dec-13, Jan-14, Feb-14, etc.). Presumably I need to sort by year first, then by month. Does anyone have an formula that will work for this?</P><P></P><P>Thank you</P><P>Mel</P></BODY></HTML> Fri, 12 Dec 2014 13:42:47 GMT 2014-12-12T13:42:47Z Expression to sort chart by two expressions https://community.qlik.com/t5/QlikView/Expression-to-sort-chart-by-two-expressions/m-p/823963#M536013 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a dimension comprised of two fields - Month and Year (=%Month&amp;' - '&amp;%Year).</P><P></P><P>I want to sort my chart so that the order is chronological (Nov-13, Dec-13, Jan-14, Feb-14, etc.). Presumably I need to sort by year first, then by month. Does anyone have an formula that will work for this?</P><P></P><P>Thank you</P><P>Mel</P></BODY></HTML> Fri, 12 Dec 2014 13:42:47 GMT https://community.qlik.com/t5/QlikView/Expression-to-sort-chart-by-two-expressions/m-p/823963#M536013 2014-12-12T13:42:47Z Re: Expression to sort chart by two expressions https://community.qlik.com/t5/QlikView/Expression-to-sort-chart-by-two-expressions/m-p/823964#M536014 <HTML><HEAD></HEAD><BODY><P>Year*100 + Month</P><P>....</P><P></P><P>in this way you have a natural sort:</P><P></P><P>201401</P><P></P><P>201408</P><P></P><P>201501</P><P>...</P><P>let me know</P></BODY></HTML> Fri, 12 Dec 2014 13:44:29 GMT https://community.qlik.com/t5/QlikView/Expression-to-sort-chart-by-two-expressions/m-p/823964#M536014 alexandros17 2014-12-12T13:44:29Z Re: Expression to sort chart by two expressions https://community.qlik.com/t5/QlikView/Expression-to-sort-chart-by-two-expressions/m-p/823965#M536015 <HTML><HEAD></HEAD><BODY><P>That's great, thank you!</P></BODY></HTML> Fri, 12 Dec 2014 13:50:58 GMT https://community.qlik.com/t5/QlikView/Expression-to-sort-chart-by-two-expressions/m-p/823965#M536015 2014-12-12T13:50:58Z Re: Expression to sort chart by two expressions https://community.qlik.com/t5/QlikView/Expression-to-sort-chart-by-two-expressions/m-p/823966#M536016 <HTML><HEAD></HEAD><BODY><P>When you create your dimension why not make it into QlikView MonthName format something like this</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; =MonthName(MakeDate('2014','11'))</P><P></P><P>Then it will sort naturally as is and generally make your like easier.</P></BODY></HTML> Fri, 12 Dec 2014 13:53:46 GMT https://community.qlik.com/t5/QlikView/Expression-to-sort-chart-by-two-expressions/m-p/823966#M536016 Anonymous 2014-12-12T13:53:46Z