topic Re: Sorting by monthyear error in QlikView https://community.qlik.com/t5/QlikView/Sorting-by-monthyear-error/m-p/62162#M779726 <HTML><HEAD></HEAD><BODY><P>Try this expression in the sort tab</P><P></P><P>Date(Date#(MonthYear,'MMMYYYY'))</P></BODY></HTML> Thu, 05 Apr 2018 14:08:32 GMT sasiparupudi1 2018-04-05T14:08:32Z Sorting by monthyear error https://community.qlik.com/t5/QlikView/Sorting-by-monthyear-error/m-p/62159#M779723 <HTML><HEAD></HEAD><BODY><P>Hi every one, </P><P></P><P>Could any one advise how to sort month year option as i have been facing problem with Jan 2017 and Jan 2018. No matter what selection was made in sorting these two months are showing at the end. Please refer the screen shot for better understanding. </P><P></P><P>Could some one help.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Sorting-by-monthyear-error/m-p/62159#M779723 bushpalaamarnat 2020-11-25T16:16:04Z Re: Sorting by monthyear error https://community.qlik.com/t5/QlikView/Sorting-by-monthyear-error/m-p/62160#M779724 <HTML><HEAD></HEAD><BODY><P>hello</P><P>you should have a field in which the date is stored in format YYYYMM and sort on this field</P><P>you may also use dual to associate this value with the content of the field used in your graph:</P><P>i mean dual(field used in your graph, date in format YYYYMM) as .....</P></BODY></HTML> Thu, 05 Apr 2018 12:22:18 GMT https://community.qlik.com/t5/QlikView/Sorting-by-monthyear-error/m-p/62160#M779724 olivierrobin 2018-04-05T12:22:18Z Re: Sorting by monthyear error https://community.qlik.com/t5/QlikView/Sorting-by-monthyear-error/m-p/62161#M779725 <HTML><HEAD></HEAD><BODY><P>Hi, thank you for your response. the month and year is in text format, using your funtion i tried doing =dual(MonthYear,Date('MMMYYYY')) and it did not work, is there something else to do?</P><P></P><P>attaching the format for reference. </P><P></P><P>Kindly advise. </P></BODY></HTML> Thu, 05 Apr 2018 13:38:03 GMT https://community.qlik.com/t5/QlikView/Sorting-by-monthyear-error/m-p/62161#M779725 bushpalaamarnat 2018-04-05T13:38:03Z Re: Sorting by monthyear error https://community.qlik.com/t5/QlikView/Sorting-by-monthyear-error/m-p/62162#M779726 <HTML><HEAD></HEAD><BODY><P>Try this expression in the sort tab</P><P></P><P>Date(Date#(MonthYear,'MMMYYYY'))</P></BODY></HTML> Thu, 05 Apr 2018 14:08:32 GMT https://community.qlik.com/t5/QlikView/Sorting-by-monthyear-error/m-p/62162#M779726 sasiparupudi1 2018-04-05T14:08:32Z