topic Re: Sort in QlikView https://community.qlik.com/t5/QlikView/Sort/m-p/1071337#M525675 <HTML><HEAD></HEAD><BODY><P>Use a numerical sort if the monthyear is read as a date. If not, then probably use expression sort with the following expression -&gt; <STRONG>Date#(monthyear, 'YourMonthYearFieldFormatHere')</STRONG></P></BODY></HTML> Tue, 12 Jan 2016 17:08:59 GMT sunny_talwar 2016-01-12T17:08:59Z Sort https://community.qlik.com/t5/QlikView/Sort/m-p/1071336#M525673 <HTML><HEAD></HEAD><BODY><P>I have applied rolling 6 months logic on opening of my qvw file, so when it opens it will select last 6 months in the current selection.</P><P>it is in monthyear format, i am not able to sort it. Can you tel me how can i sort it?</P></BODY></HTML> Tue, 12 Jan 2016 13:04:12 GMT https://community.qlik.com/t5/QlikView/Sort/m-p/1071336#M525673 2016-01-12T13:04:12Z Re: Sort https://community.qlik.com/t5/QlikView/Sort/m-p/1071337#M525675 <HTML><HEAD></HEAD><BODY><P>Use a numerical sort if the monthyear is read as a date. If not, then probably use expression sort with the following expression -&gt; <STRONG>Date#(monthyear, 'YourMonthYearFieldFormatHere')</STRONG></P></BODY></HTML> Tue, 12 Jan 2016 17:08:59 GMT https://community.qlik.com/t5/QlikView/Sort/m-p/1071337#M525675 sunny_talwar 2016-01-12T17:08:59Z