Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

timestamp to time without date

Hi,

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?

Regards,

Jon Ditchfield

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Have you used something like

time(frac([Logdate])) as [Logdate_time]

to retrieve the time only?

View solution in original post

2 Replies
swuehl
MVP
MVP

Have you used something like

time(frac([Logdate])) as [Logdate_time]

to retrieve the time only?

Not applicable
Author

you can try using

hour([Logdate] )&':'&minute([Logdate] )&':'&second([Logdate] ) as [Logdate_Time]