Discussion board where members can get started with QlikView.
Can you please help me find a solution to this problem?
I have this set of data:
For each operator i would like to get the differnce between every DATE with the previous one and them sum all of these times in order to get the final lead time; for example:
1st activity 10:41:36 - 10:40:17 --> 00:01:19
2nd activity 10:47:21 - 10:41:36 --> 00:05:45
3rd activity 10:48:02 - 10:47:21 --> 00:00:41
The total amount of time is the sum of the results above
I need to make this in backend.
Thank you in advance
I think that the Interval() function is what you need: Interval - script and chart function ‒ Qlik Sense
Interval(end_date - start_date, 'hh:mm:ss') AS Result
i've tried with Interval but it's not working; how do I get the end date in my case? I have to get the previous one for each date.