topic Re: How to sort period time (Text)? in QlikView https://community.qlik.com/t5/QlikView/How-to-sort-period-time-Text/m-p/26891#M4497 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/qlik-users/171708">stalwar1</A>‌ Can you help me?</P></BODY></HTML> Fri, 02 Feb 2018 09:19:24 GMT panwipa2528 2018-02-02T09:19:24Z How to sort period time (Text)? https://community.qlik.com/t5/QlikView/How-to-sort-period-time-Text/m-p/26888#M4494 <HTML><HEAD></HEAD><BODY><P>I have data sort as attach file and need result same as photo</P></BODY></HTML> Wed, 31 Jan 2018 09:47:34 GMT https://community.qlik.com/t5/QlikView/How-to-sort-period-time-Text/m-p/26888#M4494 panwipa2528 2018-01-31T09:47:34Z Re: How to sort period time (Text)? https://community.qlik.com/t5/QlikView/How-to-sort-period-time-Text/m-p/26889#M4495 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Check the application.</P><P></P><P>Regards,</P><P>Kaushik Solanki</P></BODY></HTML> Wed, 31 Jan 2018 10:05:20 GMT https://community.qlik.com/t5/QlikView/How-to-sort-period-time-Text/m-p/26889#M4495 kaushiknsolanki 2018-01-31T10:05:20Z Re: How to sort period time (Text)? https://community.qlik.com/t5/QlikView/How-to-sort-period-time-Text/m-p/26890#M4496 <HTML><HEAD></HEAD><BODY><P>When I have data like attach file, please help me again. _/\_</P></BODY></HTML> Thu, 01 Feb 2018 03:34:30 GMT https://community.qlik.com/t5/QlikView/How-to-sort-period-time-Text/m-p/26890#M4496 panwipa2528 2018-02-01T03:34:30Z Re: How to sort period time (Text)? https://community.qlik.com/t5/QlikView/How-to-sort-period-time-Text/m-p/26891#M4497 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/qlik-users/171708">stalwar1</A>‌ Can you help me?</P></BODY></HTML> Fri, 02 Feb 2018 09:19:24 GMT https://community.qlik.com/t5/QlikView/How-to-sort-period-time-Text/m-p/26891#M4497 panwipa2528 2018-02-02T09:19:24Z Re: How to sort period time (Text)? https://community.qlik.com/t5/QlikView/How-to-sort-period-time-Text/m-p/26892#M4498 <HTML><HEAD></HEAD><BODY><P>May be sort using this expression</P><P><STRONG>Date#(Trim(SubField(Period, '-', -1)), 'DD MMM')</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/192328_Capture.PNG" style="height: 207px; width: 620px;" /><BR /></STRONG></P></BODY></HTML> Fri, 02 Feb 2018 12:13:40 GMT https://community.qlik.com/t5/QlikView/How-to-sort-period-time-Text/m-p/26892#M4498 sunny_talwar 2018-02-02T12:13:40Z