topic Re: How to sort by a Date field in QlikView https://community.qlik.com/t5/QlikView/How-to-sort-by-a-Date-field/m-p/836836#M1007585 <HTML><HEAD></HEAD><BODY><P>You can use the Dual function to create a numeric value with different display format. See attached example.</P></BODY></HTML> Fri, 22 May 2015 16:37:43 GMT Gysbert_Wassenaar 2015-05-22T16:37:43Z How to sort by a Date field https://community.qlik.com/t5/QlikView/How-to-sort-by-a-Date-field/m-p/836835#M1007584 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>PFA the data I have in a Qlikview straight through table.&nbsp; Here the quarter field was derived from the period_start_dt field.&nbsp; The ordering I am expecting is as follows:</P><P></P><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD> <P>1Q2015</P> <P>3Q2014</P> <P>2Q2014</P> <P>1Q2014</P> </TD></TR></TBODY></TABLE></BLOCKQUOTE><P></P><P></P><P>Please assist.</P><P></P><P>Thanks,</P><P>Sudha.</P></BODY></HTML> Fri, 22 May 2015 15:34:22 GMT https://community.qlik.com/t5/QlikView/How-to-sort-by-a-Date-field/m-p/836835#M1007584 2015-05-22T15:34:22Z Re: How to sort by a Date field https://community.qlik.com/t5/QlikView/How-to-sort-by-a-Date-field/m-p/836836#M1007585 <HTML><HEAD></HEAD><BODY><P>You can use the Dual function to create a numeric value with different display format. See attached example.</P></BODY></HTML> Fri, 22 May 2015 16:37:43 GMT https://community.qlik.com/t5/QlikView/How-to-sort-by-a-Date-field/m-p/836836#M1007585 Gysbert_Wassenaar 2015-05-22T16:37:43Z Re: How to sort by a Date field https://community.qlik.com/t5/QlikView/How-to-sort-by-a-Date-field/m-p/836837#M1007586 <HTML><HEAD></HEAD><BODY><P>or sort by expression desc</P><P>Mid(Quarter,3,4) &amp; Left(Quarter,1)</P><P></P><P><IMG alt="1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/91560_1.png" style="height: auto; width: auto;" /></P></BODY></HTML> Wed, 01 Jul 2015 22:18:48 GMT https://community.qlik.com/t5/QlikView/How-to-sort-by-a-Date-field/m-p/836837#M1007586 maxgro 2015-07-01T22:18:48Z