topic Re: Sort by Expression in QlikView https://community.qlik.com/t5/QlikView/Sort-by-Expression/m-p/474442#M1143036 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try to put in the dimension <SPAN style="color: #0000ff;">Date</SPAN>(<SPAN style="color: #800000;">OrderDate</SPAN>,'MMYYYY')</P><P>and in the sort by put<SPAN style="color: #0000ff;"> date#</SPAN>(<SPAN style="color: #800000;">OrderDate</SPAN>)</P><P></P><P>BR</P><P></P><P>Ariel</P></BODY></HTML> Tue, 03 Sep 2013 09:11:35 GMT ariel_klien 2013-09-03T09:11:35Z Sort by Expression https://community.qlik.com/t5/QlikView/Sort-by-Expression/m-p/474441#M1143035 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I was trying to Sort by Expression but i'm not able to do it please answer if any one can.</P><P></P><P>i have one calculated dimension ("Month(OrderDate)&amp;Year(OrderDate)") and i have selected sort by expression ("OrderDate").</P><P>Don't know why this is not working..</P><P></P><P></P><P>Thanks in advance for your answer and effort.</P></BODY></HTML> Tue, 03 Sep 2013 09:04:34 GMT https://community.qlik.com/t5/QlikView/Sort-by-Expression/m-p/474441#M1143035 2013-09-03T09:04:34Z Re: Sort by Expression https://community.qlik.com/t5/QlikView/Sort-by-Expression/m-p/474442#M1143036 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try to put in the dimension <SPAN style="color: #0000ff;">Date</SPAN>(<SPAN style="color: #800000;">OrderDate</SPAN>,'MMYYYY')</P><P>and in the sort by put<SPAN style="color: #0000ff;"> date#</SPAN>(<SPAN style="color: #800000;">OrderDate</SPAN>)</P><P></P><P>BR</P><P></P><P>Ariel</P></BODY></HTML> Tue, 03 Sep 2013 09:11:35 GMT https://community.qlik.com/t5/QlikView/Sort-by-Expression/m-p/474442#M1143036 ariel_klien 2013-09-03T09:11:35Z Re: Sort by Expression https://community.qlik.com/t5/QlikView/Sort-by-Expression/m-p/474443#M1143037 <HTML><HEAD></HEAD><BODY><P>Instead, try <STRONG>MonthName(OrderDate)</STRONG>&nbsp; as your calculated dimension and sort by numeric order.</P></BODY></HTML> Tue, 03 Sep 2013 09:12:15 GMT https://community.qlik.com/t5/QlikView/Sort-by-Expression/m-p/474443#M1143037 tresB 2013-09-03T09:12:15Z Re: Sort by Expression https://community.qlik.com/t5/QlikView/Sort-by-Expression/m-p/474444#M1143038 <HTML><HEAD></HEAD><BODY><P>Thank you ...:)</P><P></P><P>it's working...</P></BODY></HTML> Tue, 03 Sep 2013 09:42:04 GMT https://community.qlik.com/t5/QlikView/Sort-by-Expression/m-p/474444#M1143038 2013-09-03T09:42:04Z