topic Re: Integer to duration in App Development

Integer to duration

BEKEGE — Mon, 07 Feb 2022 09:09:43 GMT

Hello,

I have durations in INTEGER format in a database.

It's integers represent running time in milliseconds.

for example: 1983000 = 00D 00H 33M 03S 00MS because: 1983000/60000 = 33.05 ==> 33min + ((05*60)/100) = 3s

How can I get this time value from the integer in QlikSense?

I tried several functions like time, timestamp or interval, but nothing seems to correspond to what I want to do.

Re: Integer to duration

chris_djih — Mon, 07 Feb 2022 14:52:06 GMT

use Interval(). The important part is the format parameter.
You may consider first transforming your number into seconds by dividing 100.

Edit: you have to match the correct qlik number by calculating SECOND_Field /86400 as Qlik_SECONDS //(=24h*60m*60s)

Re: Integer to duration

Sbarro2 — Mon, 07 Feb 2022 15:15:39 GMT

Hello,

Convert this integer to time and change it to the good format. Try this expression :

TIME(TIME#([Time_field]/1000, 'ss'),'hh:mm:ss') // The division by 1000 transform milliseconds into seconds.

Best regards.

Re: Integer to duration

MarcoWedel — Mon, 07 Feb 2022 21:09:19 GMT

Hi,

another solution might be:

table1: Load *, Interval(duration/86400000,'d hh:mm:ss.fff') as durationInterval Inline [ duration 1 10 100 1000 10000 86400 100000 1000000 1983000 1983123 10000000 86399999 86400000 86400001 100000000 171943210 ];

hope this helps

Marco