Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Skip the ticket, Chat with Qlik Support instead for instant assistance.
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: