Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP 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?