topic Number minus the same number doesn't equal zero in QlikView https://community.qlik.com/t5/QlikView/Number-minus-the-same-number-doesn-t-equal-zero/m-p/1201128#M386768 <HTML><HEAD></HEAD><BODY><P>Any help with this would be much appreciated...</P><P><IMG alt="Query.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/142469_Query.JPG" style="height: 662px; width: 620px;" /></P></BODY></HTML> Mon, 31 Oct 2016 08:43:42 GMT 2016-10-31T08:43:42Z Number minus the same number doesn't equal zero https://community.qlik.com/t5/QlikView/Number-minus-the-same-number-doesn-t-equal-zero/m-p/1201128#M386768 <HTML><HEAD></HEAD><BODY><P>Any help with this would be much appreciated...</P><P><IMG alt="Query.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/142469_Query.JPG" style="height: 662px; width: 620px;" /></P></BODY></HTML> Mon, 31 Oct 2016 08:43:42 GMT https://community.qlik.com/t5/QlikView/Number-minus-the-same-number-doesn-t-equal-zero/m-p/1201128#M386768 2016-10-31T08:43:42Z Re: Number minus the same number doesn't equal zero https://community.qlik.com/t5/QlikView/Number-minus-the-same-number-doesn-t-equal-zero/m-p/1201129#M386769 <HTML><HEAD></HEAD><BODY><P>1 second is not exactly equal to 0.000011574</P><P>When I do the calculation in Excel I get: 0000115740740740741, but that is not exactly right either because of rounding errors and converting between base 2 and base 10.</P><P></P><P>I usually use just the Date part when I do incremental loads. </P></BODY></HTML> Mon, 31 Oct 2016 19:14:23 GMT https://community.qlik.com/t5/QlikView/Number-minus-the-same-number-doesn-t-equal-zero/m-p/1201129#M386769 m_woolf 2016-10-31T19:14:23Z Re: Number minus the same number doesn't equal zero https://community.qlik.com/t5/QlikView/Number-minus-the-same-number-doesn-t-equal-zero/m-p/1201130#M386770 <HTML><HEAD></HEAD><BODY><P>Solved it.&nbsp; Using the interval function.&nbsp; </P></BODY></HTML> Tue, 01 Nov 2016 08:30:12 GMT https://community.qlik.com/t5/QlikView/Number-minus-the-same-number-doesn-t-equal-zero/m-p/1201130#M386770 2016-11-01T08:30:12Z