Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Comparing dates in the same field in QV?

I can't seem to find a solution for this because all of the QlikCommunity examples I'm finding deal with two dates in seperate columns per record. I simply want to count up the number of days between certain timestamped records in QlikView. The problem I'm working on is a kind of auditing log, where the date a project was started is logged, and another record is created when the project is completed. I want to have a sum of how many days elapsed, and for each project as the dimension.

2 Replies
swuehl
MVP
MVP

Try your projectID as dimension and

=interval( only({<progress = {deployed}>} entry_date ) - only({<progress = {started}>} entry_date) )

as expression.

edit: sample attached

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Great solution. I liked it so much I blogged about it here:

http://qlikviewnotes.blogspot.com/2013/07/calculating-duration-using-to-rows.html

-Rob