topic Sort by expression in QlikView

Sort by expression

drohm002 — Wed, 25 Nov 2020 16:16:04 GMT

Hi, I have a field called TIME, which has values like '730am-8am', '8am-830am', etc. How can i create an expression to sort these so that they show up in my table chart in chronological order? thank you! None of the default sort suggestions would put the values in chronological order...

Re: Sort by expression

rwunderlich — Thu, 07 May 2020 20:55:38 GMT

It'a a little awkward because you have to account for the various formats, but how about a sort expression like:

=Time(
Alt(
Time#(SubField(TIME,'-',1),'htt'),
Time#(SubField(TIME,'-',1),'hmmtt'),
Time#(SubField(TIME,'-',1),'hhmmtt')
)
)

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com