Calculate time difference between timestamps on different rows
Hello,
I have a view on the table in the database that contains all orderlines to be picked in the warehouse.
A person starts an order that containers multiple lines for 1 customer.
Those lines are then processed in order of closest location in the warehouse.
When the person starts a line on his barcodescanner a "start-timestamp" is written into the table.
now i calculate in excel the time between the timestamp on 1 row and the time stamp on the row before, but only if the previous row has the same id_picking and the it is being treated on is the same day.
If the Id-picking or the date of the picking is not the same as the previous row i add a standard time of 2 minutes, assuming that's the time it takes to start a new order or restart the same order but on the next working day.
In excel this is rather simple, i first order all the data on the date of the picking, picking Id and then the timestamp. that way i am sure that if i compare to the previous row it is correct.
But if i import this view into qlikview then i'm stuck on how to do this.
