topic Travel time between two appointments in QlikView

Travel time between two appointments

darren_dixon — Wed, 28 Nov 2012 14:50:45 GMT

I am trying to calculate the time between the End Time of the first appointment and the Start Time of the second appointment.

All columns are fields except time taken which is an expression of: sum(End Time-Start Time)

Hope you can help.

Thanks,

Darren

Re: Travel time between two appointments

Gysbert_Wassenaar — Wed, 28 Nov 2012 14:59:26 GMT

If the start times are ordered you can use [Start Time] - above([End Time]). The caveat is that this will simply pick the End Time of the row above. It does not take into account date changes or changes of Operative. It may be better addressed in the load script using the previous or peek function. It's easier to order the data and make sure that the travel time isn't calculated over the day changes or other changes of operative.

Re: Travel time between two appointments

darren_dixon — Wed, 28 Nov 2012 15:07:30 GMT

Hi Gysbert,

Unfortunately this has not worked. The dates and start times aren't in any order and a sort is required on the Straight table to put them in order