Skip to main content
Marching toward a simplified navigation! READ ON
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

Try your projectID as dimension and

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

as expression.

edit: sample attached

Partner Ambassador/MVP
Partner Ambassador/MVP

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