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

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

canmarroig — Fri, 16 Nov 2012 11:40:27 GMT

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

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

swuehl — Fri, 16 Nov 2012 11:55:09 GMT

Try

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

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

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

canmarroig — Fri, 16 Nov 2012 14:31:55 GMT

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

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

Wed, 12 Jul 2017 09:10:59 GMT

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