time (hh:mm:ss)

[#1]

Hello

I need to show value  (second) in this format  (hh:mm:ss)in a Qliksense chart ? it doesn't give the right results instead of 00:21:13  it shows 51234:04:01 .

Thank you in advance

[sunny_talwar]

Try this may be:

Time(Frac(TimeField), 'hh:mm:ss)

[#3]

doesn't work

[sunny_talwar]

Are you using any formatting when you see 51234:04:01? or is this how it is coming directly from your database? If you are using a formatting what is it and what do you see when you remove the formatting (direct database output)?

[rubenmarin]

Hi, if your input data is in seconds you need to tell this to qlikview (as for QV 1=1 day):

Time(Time#(secondsValue, 's'), 'hh:mm:ss')

or:

Time(secondsValue/86400, 'hh:mm:ss') //There are 86400 seconds in a day

[syukyo_zhu]

hi

what's your value numeric

[#7]

I did find the solution to my problem, basicly in the expression area you should put

Interval(value/(24*60), 'hh.mm.ss') , value being in minutes

and in the Number formating area of the chart you should choose Time and customize the format the way you want.

Regards