https://community.qlik.com/t5/QlikView/Help-in-sorting/m-p/1939256#M1219267 <P>If you sort by Text it should be correct.</P> Fri, 03 Jun 2022 04:07:16 GMT Lisa_P 2022-06-03T04:07:16Z https://community.qlik.com/t5/QlikView/Help-in-sorting/m-p/1939233#M1219266 <P>Hi All,</P> <P>I am using a filter with text field but the values is below -</P> <P>How to sort it by year wise.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ashmitp869_0-1654216817449.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/80943i7544C63240F17F20/image-size/medium?v=v2&amp;px=400" role="button" title="ashmitp869_0-1654216817449.png" alt="ashmitp869_0-1654216817449.png" /></span></P> <P>&nbsp;</P> Fri, 03 Jun 2022 00:41:30 GMT https://community.qlik.com/t5/QlikView/Help-in-sorting/m-p/1939233#M1219266 ashmitp869 2022-06-03T00:41:30Z https://community.qlik.com/t5/QlikView/Help-in-sorting/m-p/1939256#M1219267 <P>If you sort by Text it should be correct.</P> Fri, 03 Jun 2022 04:07:16 GMT https://community.qlik.com/t5/QlikView/Help-in-sorting/m-p/1939256#M1219267 Lisa_P 2022-06-03T04:07:16Z https://community.qlik.com/t5/QlikView/Help-in-sorting/m-p/1939263#M1219268 <P>Sort by text as suggested by&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/5905">@Lisa_P</a>&nbsp;</P> <P>OR</P> <P>sort by expression as</P> <P>=aggr( subfield(FiscalYear,'/',1),<SPAN>FiscalYear)</SPAN></P> <P>&nbsp;</P> Fri, 03 Jun 2022 04:48:51 GMT https://community.qlik.com/t5/QlikView/Help-in-sorting/m-p/1939263#M1219268 vinieme12 2022-06-03T04:48:51Z