topic Re: Convert seconds into hh:mm:ss format in QlikView

Convert seconds into hh:mm:ss format

bindu_apte — Mon, 26 May 2014 05:08:33 GMT

hi All,

I have a requirement where in i should display time in hh:mm:ss format and the field is in seconds, when i try using the below expression

Time(Time#(fieldname,'ss'),'hh:mm:ss'), am not getting correct value.

In precise, if the value is more than 24hours, it is not considering. It is subtracting from 24hours and rest is displayed i believe.

Ex:120720s it should give (33:32:00) instead it is giving 9:32:00

Please come up with the correct expression and explaination.

Thanka in advance,

Bindu

amit_saini — Mon, 26 May 2014 05:12:51 GMT

Hi Bindu,

Please try this:

Go to chart properties-:> Number-> select Time option and here you can change the format.

Thanks,
AS

ashfaq_haseeb — Mon, 26 May 2014 05:24:38 GMT

Hi,

try the below code.

=interval(timestamp#(120720, 's'), 'hh:mm:ss')

Regards

ASHFAQ

bindu_apte — Mon, 26 May 2014 05:28:12 GMT

Hi,

Thanks for your reply.

In our dashboard we are using the field as a dimension not in expression.

If we are using in expression and changing the format under number we are getting wrong value.

Thanks

bindu_apte — Mon, 26 May 2014 05:30:34 GMT

Thanks Ashfaq,

Its working 🙂

Fri, 30 May 2014 20:39:50 GMT

Having this exact issue and happy to find the correct answer here Thanks Ashfaq!