If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I have field Runtime with values in seconds- sum(Runtime).How to get Runtime in minutes in qliksense load script
Interval(Interval#(sum(Runtime), 's'), 'm:s')
or if you only need whole minutes:
round(Sum(Runtime) / 60)
May be divide it by 60?
Interval(Interval#(Sum(runtime), 'ss'), 'mm:ss')
What does divide by Sum(Runtine in seconds)/86400 would do ?
What does Sum(runtime in seconds)/1440 would do?
Hey Rob -
'm:s' might not show the correct seconds... although underlying value will be correct. I think 'm:ss' would be correct
24*60*60 = 86400 will convert seconds into days
24*60 = 1440 will convert minutes into days... but won't really mean much for seconds
in case I have to show runtime over span of days shown in another chart, I should divide it by(86400)