Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
DanCasSan
Contributor III
Contributor III

Calculate the average time from point to point

Hello partners!

Could someone help me with this calculation? I want to calculate the average travel time of a supplier from when he enters until he leaves a position, this supplier can enter several times a day and it is necessary to determine the time it takes him to be in each position.

My information has the following structure:

DanCasSan_0-1666557011067.png

Thank you for your support!

Cheers,
DC

Labels (5)
1 Reply
Dalton_Ruer
Support
Support

Check out this post I worte years ago about how to use the Qlik Script function called PREVIOUS that lets you see the previous row of data. Concept is sort the way you read the input data and then you can compare a value in the current row to the value in the previous row. 

 

http://qlikdork.com/2016/07/visualizing-readmissions/