Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
mick1234
New 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))))

Labels (1)
1 Reply
bing_jville
New Contributor III

Re: Correct script(date calculation)

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