Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. $300 savings extended to February 9th Learn More
Highlighted
bindu_apte
Contributor 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

Re: Convert seconds into hh:mm:ss format

Hi,

try the below code.

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

Regards

ASHFAQ

View solution in original post

5 Replies
amit_saini
Honored Contributor III

Re: Convert seconds into hh:mm:ss format

Hi Bindu,

Please try this:

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

Thanks,
AS

Re: Convert seconds into hh:mm:ss format

Hi,

try the below code.

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

Regards

ASHFAQ

View solution in original post

bindu_apte
Contributor III

Re: Convert seconds into hh:mm:ss format

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
Contributor III

Re: Convert seconds into hh:mm:ss format


Thanks Ashfaq,

Its working 🙂

Not applicable

Re: Convert seconds into hh:mm:ss format

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