Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
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
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