topic Re: Time in hh:mm:ss in QlikView

Time in hh:mm:ss

ferha_jafri — Wed, 26 Mar 2014 04:21:51 GMT

Hello Everyone,

I need help asap , it is urgent , i have time field in which the time is mentioned in a format is 31245 means 3 hr 12 min and 45 sec, how i can get in the format as 03:12:45.If anyone knows the ans please reply asap.I am attaching a sample.

Re: Time in hh:mm:ss

amit_saini — Wed, 26 Mar 2014 04:29:40 GMT

Hi Ferha,

Please use these:

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

dual( Date(TS,'YYYY-MM-DD') &'T' & time(TS,'hh:mm:ss'), num(TS) ) as Timestamp,

trim(Time(timestamp, 'hh:mm:ss')) as my_time

Thanks,

Re: Time in hh:mm:ss

Wed, 26 Mar 2014 04:31:42 GMT

try this

Time(Time#(fieldname,'hmmss'),'hh:mm:ss') as NewTime

******************************************

in text object try this

=Time(Time#('31245','hmmss'),'hh:mm:ss')

Re: Time in hh:mm:ss

preminqlik — Wed, 26 Mar 2014 04:34:43 GMT

time(time#(num(fieldname,'000000'),'hhmmss'),'hh:mm:ss') as TIME

Re: Time in hh:mm:ss

ferha_jafri — Wed, 26 Mar 2014 04:39:41 GMT

Thank you So much Vishwaranjan

Re: Time in hh:mm:ss

qlikpahadi07 — Wed, 26 Mar 2014 04:57:54 GMT

Modifying the logic try this in text box

=if(len(Time) =5, Time(Time#(Time,'hmmss'),'hh:mm:ss') ,

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

because if values are "145650" above expression will work for both