Calculate time difference between timestamps on different rows

chriscools — Sat, 28 Nov 2020 14:39:54 GMT

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.

Anybody who might have an idea on how to do this?

i attached a subset of the data.

thanx a lot!

Chris

Re: Calculate time difference between timestamps on different rows

Kushal_Chawda — Sat, 28 Nov 2020 16:13:26 GMT

@chriscools see the attached

Re: Calculate time difference between timestamps on different rows

chriscools — Sat, 12 Dec 2020 12:00:54 GMT

Thanx a lot! That worked great!

Now i can also implement this for the other scanprocesses.

grtz,

Chris

topic Calculate time difference between timestamps on different rows in QlikView

Calculate time difference between timestamps on different rows

Re: Calculate time difference between timestamps on different rows

Re: Calculate time difference between timestamps on different rows