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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
DanCasSan
Contributor III
Contributor III
‎2022-10-23 04:30 PM

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)
644 Views
0 Likes
1 Reply
Dalton_Ruer
Support
Support
‎2022-11-09 09:54 AM

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/

571 Views
0 Likes