Calculating Elapsed Time

Tue, 15 Oct 2013 13:18:55 GMT

Hi,

I am very new to QlikView so apologies is my question is quite basic.

I need to build a bar chart in QV to show the distribution of elapsed time in days between tasks for each case in a process.

My x axis should show the number of days and my y axis will show the number of cases.

My data contains a completion date for each task as the cases moves through the process. To calculate the time per task I need to use the completion date of one task less the completion date of the previous task.

I have made numerous attempts at creating the chart without any succes so any help would be very much apreciated.

Hopefully I've made myself clear.

Thanks a lot!

Re: Calculating Elapsed Time

swuehl — Tue, 15 Oct 2013 13:35:42 GMT

It would be helpful, if you could post some sample lines of data.

In principle, I would calculate the duration of a task in the script, since the duration should not depend on selections.

You can use peek() function to access the previous row when reading in your data, in a simple version like

LOAD

Task,

EndDate,

EndDate - peek(EndDate) as Duration

FROM ...;

Then use Duration field as dimension and count(Task) as expression.

edit: You need to take care of the order of your input data, so you may need to add a sort by EndDate

topic Calculating Elapsed Time in QlikView

Calculating Elapsed Time

Re: Calculating Elapsed Time