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

Announcements
Join us in Bucharest on Sept 18th 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?