Solved: Re: How to sort period time (Text)? - Qlik Community

panwipa2528 · ‎2018-01-31

I have data sort as attach file and need result same as photo

sunny_talwar · ‎2018-02-02

May be sort using this expression

Date#(Trim(SubField(Period, '-', -1)), 'DD MMM')

kaushiknsolanki · ‎2018-01-31

Hi,

Check the application.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

panwipa2528 · ‎2018-01-31

When I have data like attach file, please help me again. _/\_

panwipa2528 · ‎2018-02-02

stalwar1‌ Can you help me?

sunny_talwar · ‎2018-02-02

May be sort using this expression

Date#(Trim(SubField(Period, '-', -1)), 'DD MMM')