topic Re: Comparing dates in the same field in QV? in QlikView https://community.qlik.com/t5/QlikView/Comparing-dates-in-the-same-field-in-QV/m-p/487879#M182282 <HTML><HEAD></HEAD><BODY><P>Try your projectID as dimension and</P><P></P><P>=interval( only({&lt;progress = {deployed}&gt;} entry_date ) - only({&lt;progress = {started}&gt;} entry_date) ) </P><P></P><P>as expression.</P><P></P><P>edit: sample attached</P></BODY></HTML> Tue, 16 Jul 2013 21:06:51 GMT swuehl 2013-07-16T21:06:51Z Comparing dates in the same field in QV? https://community.qlik.com/t5/QlikView/Comparing-dates-in-the-same-field-in-QV/m-p/487878#M182281 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Tue, 16 Jul 2013 20:56:39 GMT https://community.qlik.com/t5/QlikView/Comparing-dates-in-the-same-field-in-QV/m-p/487878#M182281 2013-07-16T20:56:39Z Re: Comparing dates in the same field in QV? https://community.qlik.com/t5/QlikView/Comparing-dates-in-the-same-field-in-QV/m-p/487879#M182282 <HTML><HEAD></HEAD><BODY><P>Try your projectID as dimension and</P><P></P><P>=interval( only({&lt;progress = {deployed}&gt;} entry_date ) - only({&lt;progress = {started}&gt;} entry_date) ) </P><P></P><P>as expression.</P><P></P><P>edit: sample attached</P></BODY></HTML> Tue, 16 Jul 2013 21:06:51 GMT https://community.qlik.com/t5/QlikView/Comparing-dates-in-the-same-field-in-QV/m-p/487879#M182282 swuehl 2013-07-16T21:06:51Z Re: Comparing dates in the same field in QV? https://community.qlik.com/t5/QlikView/Comparing-dates-in-the-same-field-in-QV/m-p/487880#M182283 <HTML><HEAD></HEAD><BODY><P>Great solution. I liked it so much I blogged about it here:</P><P><A class="loading" href="http://qlikviewnotes.blogspot.com/2013/07/calculating-duration-using-to-rows.html">http://qlikviewnotes.blogspot.com/2013/07/calculating-duration-using-to-rows.html</A></P><P></P><P>-Rob</P></BODY></HTML> Wed, 17 Jul 2013 02:18:11 GMT https://community.qlik.com/t5/QlikView/Comparing-dates-in-the-same-field-in-QV/m-p/487880#M182283 rwunderlich 2013-07-17T02:18:11Z