topic time format in QlikView

time format

Tue, 15 May 2012 16:08:33 GMT

hi,

i have two kind of time formats:

00:01:10 wich is hh:mm:ss and 01:10 wich is mm:ss.

i need to convert the second format to hh:mm:ss

how can i do this?

i've tried with timestamp# (date,'hh:mm:ss') and whit Date#(date,'hh:mm:ss) but it didn't do what i need.

thanks for your help!

swuehl — Tue, 15 May 2012 16:13:12 GMT

Try using the alt() function in combination with interval# / interval functions:

LOAD

...

interval(alt(interval#(Duration,'hh:mm:ss'),interval#(Duration,'mm:ss')),'hh:mm:ss') as NewField,

...

FROM ...

Jason_Michaelides — Tue, 15 May 2012 16:14:19 GMT

try:

Time(Time#(Duration,'mm:ss'),'hh:mm:ss')

Hope this helps,

Jason

Tue, 15 May 2012 16:22:06 GMT

thanks for your answer it really helped me.