Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bindu_apte
Creator III
Creator III

Convert seconds into hh:mm:ss format

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


1 Solution

Accepted Solutions
ashfaq_haseeb
Champion III
Champion III

Hi,

try the below code.

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

Regards

ASHFAQ

View solution in original post

5 Replies
amit_saini
Master III
Master III

Hi Bindu,

Please try this:

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

Thanks,
AS

ashfaq_haseeb
Champion III
Champion III

Hi,

try the below code.

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

Regards

ASHFAQ

bindu_apte
Creator III
Creator III
Author

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
Creator III
Creator III
Author


Thanks Ashfaq,

Its working 🙂

Not applicable

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