Comparing dates in the same field in QV?

[#1]

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.

[swuehl]

Try your projectID as dimension and

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

as expression.

edit: sample attached

[rwunderlich]

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