topic Re: [Month Year] Sort Help in QlikView https://community.qlik.com/t5/QlikView/Month-Year-Sort-Help/m-p/26499#M780672 <HTML><HEAD></HEAD><BODY><P>Or sort by expression as below</P><P></P><P>Date#([Month Year],'YYYY MMM')</P></BODY></HTML> Wed, 28 Mar 2018 18:24:12 GMT MK_QSL 2018-03-28T18:24:12Z [Month Year] Sort Help https://community.qlik.com/t5/QlikView/Month-Year-Sort-Help/m-p/26497#M780670 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Trying to sort [Month Year] data is in the form 2016 Jan.....2017 Jan... 2018 Jan.</P><P></P><P>Thanks for the help <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Month-Year-Sort-Help/m-p/26497#M780670 rxp03570 2020-11-25T16:16:04Z Re: [Month Year] Sort Help https://community.qlik.com/t5/QlikView/Month-Year-Sort-Help/m-p/26498#M780671 <HTML><HEAD></HEAD><BODY><P>May be try sorting using this expression</P><P></P><P><STRONG>Month([Month Year])*100000 + Year([Month Year])</STRONG></P></BODY></HTML> Wed, 28 Mar 2018 18:22:16 GMT https://community.qlik.com/t5/QlikView/Month-Year-Sort-Help/m-p/26498#M780671 sunny_talwar 2018-03-28T18:22:16Z Re: [Month Year] Sort Help https://community.qlik.com/t5/QlikView/Month-Year-Sort-Help/m-p/26499#M780672 <HTML><HEAD></HEAD><BODY><P>Or sort by expression as below</P><P></P><P>Date#([Month Year],'YYYY MMM')</P></BODY></HTML> Wed, 28 Mar 2018 18:24:12 GMT https://community.qlik.com/t5/QlikView/Month-Year-Sort-Help/m-p/26499#M780672 MK_QSL 2018-03-28T18:24:12Z Re: [Month Year] Sort Help https://community.qlik.com/t5/QlikView/Month-Year-Sort-Help/m-p/26500#M780682 <HTML><HEAD></HEAD><BODY><P>I might have misunderstood... but this will sort like this</P><P></P><P>Jan 2016</P><P>Feb 2016</P><P>Mar 2016</P><P>.</P><P>.</P><P>.</P><P>Dec 2016</P><P>Jan 2017</P><P>Feb 2017</P><P>Mar 2017</P><P>.</P><P>.</P><P>.</P><P>Dec 2017</P><P>Jan 2018</P><P>.</P><P>.</P><P>.</P><P></P><P>From what I understood, the sorting needed is like this</P><P></P><P>Jan 2016</P><P>Jan 2017</P><P>Jan 2018</P><P>Feb 2016</P><P>Feb 2017</P><P>Feb 2018</P><P>.</P><P>.</P><P>.</P><P></P><P>If the above is not what is needed then I would use <A href="https://community.qlik.com/people/mrkachhiaimp">mrkachhiaimp</A>‌'s expression for sure</P></BODY></HTML> Wed, 28 Mar 2018 18:27:06 GMT https://community.qlik.com/t5/QlikView/Month-Year-Sort-Help/m-p/26500#M780682 sunny_talwar 2018-03-28T18:27:06Z Re: [Month Year] Sort Help https://community.qlik.com/t5/QlikView/Month-Year-Sort-Help/m-p/26501#M780685 <HTML><HEAD></HEAD><BODY><P>I guess I was wrong <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 28 Mar 2018 18:28:37 GMT https://community.qlik.com/t5/QlikView/Month-Year-Sort-Help/m-p/26501#M780685 sunny_talwar 2018-03-28T18:28:37Z