Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

Hi,

try the below code.

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

Regards

ASHFAQ

View solution in original post

5 Replies
Highlighted
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

Highlighted

Hi,

try the below code.

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

Regards

ASHFAQ

View solution in original post

Highlighted
Creator III
Creator III

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

Highlighted
Creator III
Creator III


Thanks Ashfaq,

Its working 🙂

Highlighted
Not applicable

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