Discussion Board for collaboration related to QlikView App Development.
I have wrote and expression in my load script that converts the timestamp field [Logdate] into a time field called [Logdate_time].
However when I go my list box and select the newly created [Logdate_time] field, it sorts it by its numerical value. However the numerical value also includes the date.
Is there a way that I can sort it by just the time so the time shows from 00:00:00 to 23:59:59?
Have you used something like
time(frac([Logdate])) as [Logdate_time]
to retrieve the time only?
View solution in original post
you can try using
hour([Logdate] )&':'&minute([Logdate] )&':'&second([Logdate] ) as [Logdate_Time]