Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
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


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