topic Calculating Time Duration in QlikView

Calculating Time Duration

Karl_Hart — Thu, 19 Nov 2015 09:51:34 GMT

Hi,

I have a database which has a sequence of events for different operatives and I need to calculate how they are spending their time. So for example, I would have a sequence

08:00 Log in

08:10 Answer Call

08:20 Call End

08:20 Start Break

08:40 Answer Call

09:00 Call End

So I need to see how long in that hour was spent on each activity (e.g 10 minutes idol time, 30 minutes on calls, 20 minutes break)

Because there is no "Start Time" and "End Time" for each activity, I'm struggling to do calculate this. I thought about using the peek function but it's not something I have used so much before and I didnt know how this would work when there are multiple operatives

See the attached for a very simple example, hopefully you guys can help me

Thanks

Re: Calculating Time Duration

swuehl — Thu, 19 Nov 2015 15:37:58 GMT

You can do it like in attached sample.

I've created additional records for start and end work time per Operative, alternatively, you can calculate the idle time in a chart expression only if the start and end work times are identical for all Operatives. Both alternatives shown in the sample.

Re: Calculating Time Duration

Karl_Hart — Thu, 19 Nov 2015 15:54:01 GMT

Many thanks, that's a great solution.