
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!
- Tags:
- new_to_qlikview


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
