topic Sum the difference between two dates in QlikView https://community.qlik.com/t5/QlikView/Sum-the-difference-between-two-dates/m-p/284038#M105543 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a simple sum(if(condition,today() - earlier_date))&nbsp; and I'm getting an incorrect answer.&nbsp; The correct answer should be 1083 based on manually looking at the data but the answer I'm getting is 30 680.&nbsp; Individually, each line is reflecting the correct TAT but the sum of the TATs is wrong.&nbsp; </P><P></P><P>Any ideas?</P><P></P><P>Thanks,</P><P>S</P><P></P><DIV class="mcePaste" id="_mcePaste" style="position: absolute; width: 1px; height: 1px; overflow: hidden; top: 0px; left: -10000px;"></DIV></BODY></HTML> Mon, 09 May 2011 12:33:53 GMT 2011-05-09T12:33:53Z Sum the difference between two dates https://community.qlik.com/t5/QlikView/Sum-the-difference-between-two-dates/m-p/284038#M105543 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a simple sum(if(condition,today() - earlier_date))&nbsp; and I'm getting an incorrect answer.&nbsp; The correct answer should be 1083 based on manually looking at the data but the answer I'm getting is 30 680.&nbsp; Individually, each line is reflecting the correct TAT but the sum of the TATs is wrong.&nbsp; </P><P></P><P>Any ideas?</P><P></P><P>Thanks,</P><P>S</P><P></P><DIV class="mcePaste" id="_mcePaste" style="position: absolute; width: 1px; height: 1px; overflow: hidden; top: 0px; left: -10000px;"></DIV></BODY></HTML> Mon, 09 May 2011 12:33:53 GMT https://community.qlik.com/t5/QlikView/Sum-the-difference-between-two-dates/m-p/284038#M105543 2011-05-09T12:33:53Z Sum the difference between two dates https://community.qlik.com/t5/QlikView/Sum-the-difference-between-two-dates/m-p/284039#M105544 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Maybe the some value are duplicate.</P><P></P><P>Do you can show your example or qvw file?</P><P></P><P>Thanks</P></BODY></HTML> Mon, 09 May 2011 12:52:30 GMT https://community.qlik.com/t5/QlikView/Sum-the-difference-between-two-dates/m-p/284039#M105544 2011-05-09T12:52:30Z