Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculating Elapsed Time

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!

1 Reply
swuehl
MVP

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