Sort a Time

[#1]

Hello,

i would like to sort a date with time for example

31.01.2016 00:12:24

31.01.2016 00:02:24

the korrect sort are

31.01.2016 00:02:24

31.01.2016 00:12:24

How can i do this?

[sunny_talwar]

You want to do this in Script or front end? If your timestamp is read correctly as a timestamp by QlikView then you can just sort your date time field by Numeric Value or using Order by FIELDNAME; in the script. If date time field is not read correctly, I would suggest fixing it. Helpful links to help you fix date time

Why don’t my dates work?

Get the Dates Right

[vinieme12]

See below,  in Sort tab >> Sort by Expression >> =SortOrder

LOAD *,NUM(Timestamp#(DateTimeIS,'dd.mm.yyyy hh:mm:ss')) as SortOrder INLINE [

DateTimeIS

31.01.2016 00:12:24

31.01.2016 00:02:24

];