Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
mick1234
Contributor II
Contributor II

Correct script(date calculation)

Hi fellos, 

Can somebody have idea why my calculation stop counting  and reset calculation based on 24 hours? 

Capture.PNG

((round(((((hour(((RangeSum((EVENT_TS2)))-min(TOTAL (RangeSum((EVENT_TS2)))))))*60))+minute(((RangeSum((EVENT_TS2)))-min(TOTAL (RangeSum((EVENT_TS2)))))))*60000/TPR))))

1 Reply
bing_jville
Contributor III
Contributor III

Could you add the TPR as a column in the table?