Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
jasmeenkr
Contributor
Contributor

RunTime in seconds to Runtime in minutes

Hi ALl,

 

I have field Runtime with values in seconds- sum(Runtime).How to get Runtime in minutes in qliksense load script

Labels (3)
6 Replies
rwunderlich

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

 

sunny_talwar

May be divide it by 60?

Sum(runtime)/60

or

Interval(Interval#(Sum(runtime), 'ss'), 'mm:ss')

jasmeenkr
Contributor
Contributor
Author

What does divide by Sum(Runtine in seconds)/86400 would do ?

What does Sum(runtime in seconds)/1440 would do?

sunny_talwar

Hey Rob - 

'm:s' might not show the correct seconds... although underlying value will be correct. I think 'm:ss' would be correct

image.png

sunny_talwar

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

jasmeenkr
Contributor
Contributor
Author

Ok.Thanks

in case I have to show runtime over span of days shown in another chart, I should divide it by(86400)