Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

canmarroig
New Contributor II

Convert a integer number in seconds to dd:hh:mm:ss

I've a integer number in seconds: 4.603.422, that I obtain from an expression and i'd like to transfom in: day:hh:mm:ss

I've tried with number format, but result is 00:00:00, then a tried to use functions like time, timestamp, maketime with or without # but i can achieve my target. Is there a function to solve this trouble or have I to calculate dd:hh:mm:ss concatenating different expression to extract separately day, hours and so on?

Who can help me, pls? Tks in advance

Tags (3)
1 Solution

Accepted Solutions
MVP
MVP

Re: Convert a integer number in seconds to dd:hh:mm:ss

Try

=interval(interval#(4603422,'ss'),'d hh:mm:ss')

or

=interval(interval#(FIELDWITHSECONDS,'ss'),'d hh:mm:ss')

3 Replies
MVP
MVP

Re: Convert a integer number in seconds to dd:hh:mm:ss

Try

=interval(interval#(4603422,'ss'),'d hh:mm:ss')

or

=interval(interval#(FIELDWITHSECONDS,'ss'),'d hh:mm:ss')

canmarroig
New Contributor II

Re: Convert a integer number in seconds to dd:hh:mm:ss

I've created a variable with my sum and'ive put it inside expression. Excellent!! Tks

Not applicable

Re: Convert a integer number in seconds to dd:hh:mm:ss

Hi Stefan,this is working perfectly. But, I have customer requirement that, If we download this to excel and select couple if rows, we can only count of the rows but not the sum.

Say I have these values,

03:04:46:45

02:22:18:05

If we select these, excel should show 05:27:04:50 in the right corner bottom of Excel. Help me out in this.

Thanks