Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
microwin88x
Creator III
Creator III

Solved

Solved

1 Solution

Accepted Solutions
sunny_talwar

Try this:

Time(If(Len(Trim(TimeField)) = 0, 0, TimeField), 'hh:mm:ss')

View solution in original post

3 Replies
sunny_talwar

Try this:

Time(If(Len(Trim(TimeField)) = 0, 0, TimeField), 'hh:mm:ss')

its_anandrjs

Share a sample file or you can do some think this ways

  LOAD *,if(IsNull(Col) = -1 or Len(Col)=1,'00:00:00',Col) as Chk;
load * Inline
[
Col
12:10:34
10:12:34
01:23:45
-
23:12:28
11:34:49
]
;


Capture.PNG


Regards

Anand

roger_stone
Creator III
Creator III

Something like this?

IF (ISNULL(mytimefield), MAKETIME(0,0,0), mytimefield) AS mytimefield