Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ALl,
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)
-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com
May be divide it by 60?
Sum(runtime)/60
or
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
Ok.Thanks
in case I have to show runtime over span of days shown in another chart, I should divide it by(86400)