topic Sort order in QlikView https://community.qlik.com/t5/QlikView/Sort-order/m-p/1446849#M807777 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>i&nbsp; want to sort the&nbsp; bar chart&nbsp; order by yearmonth</P><P></P><P>2011-mar</P><P>2012-apr</P><P>2013-may</P><P>2014-jun</P><P></P><P>i want above order&nbsp;&nbsp; ,but now its giving mix order</P><P></P><P>how can i achieve this?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT kicchu465 2020-11-25T16:16:04Z Sort order https://community.qlik.com/t5/QlikView/Sort-order/m-p/1446849#M807777 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>i&nbsp; want to sort the&nbsp; bar chart&nbsp; order by yearmonth</P><P></P><P>2011-mar</P><P>2012-apr</P><P>2013-may</P><P>2014-jun</P><P></P><P>i want above order&nbsp;&nbsp; ,but now its giving mix order</P><P></P><P>how can i achieve this?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Sort-order/m-p/1446849#M807777 kicchu465 2020-11-25T16:16:04Z Re: Sort order https://community.qlik.com/t5/QlikView/Sort-order/m-p/1446850#M807778 <HTML><HEAD></HEAD><BODY><P>Fix this in the script by helpful read your yearmonth field as a date field which has an underlying numeric value. Once you do this, you will be able to sort it numerically</P><P></P><P><STRONG>LOAD Date(MonthStart(yearmonth, 'YYYY-MMM')), 'YYYY-MMM') as yearmonth</STRONG></P></BODY></HTML> Fri, 27 Oct 2017 16:37:16 GMT https://community.qlik.com/t5/QlikView/Sort-order/m-p/1446850#M807778 sunny_talwar 2017-10-27T16:37:16Z