https://community.qlik.com/t5/App-Development/Interval-function-in-Qlik-Sense/m-p/2518120#M106045 <P>Hi, 3.77 is the correct value, isn't? If you want to reduce to full days you can use Sum(Floor(DUR)) to reduce each value to the lowest integer, or Floor(Sum(DUR)) to reduce the result</P> Sun, 18 May 2025 07:03:54 GMT rubenmarin 2025-05-18T07:03:54Z https://community.qlik.com/t5/App-Development/Interval-function-in-Qlik-Sense/m-p/2518113#M106039 <P>I am using Interval function to find the difference between two timestamps in days and it is giving me the exact result in data load editor. But while using this calculated field in charts, it is showing a different value.</P><P>Below is the data snippet that needs the clarification</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="RajuNatesan_0-1747488659440.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/180553i5F935DEAAA8364E1/image-size/medium?v=v2&amp;px=400" role="button" title="RajuNatesan_0-1747488659440.png" alt="RajuNatesan_0-1747488659440.png" /></span></P><P>Interval function used in Qlik Sense Data Load editor :&nbsp;Interval(TS-1 - TS-2, 'd') as DUR.</P><P>When I use SUM(DUR) in table chart, it is showing me 3.77, against 3.</P><P>Any suggestions on how to get this issue fixed</P> Sat, 17 May 2025 13:34:32 GMT https://community.qlik.com/t5/App-Development/Interval-function-in-Qlik-Sense/m-p/2518113#M106039 RajuNatesan 2025-05-17T13:34:32Z https://community.qlik.com/t5/App-Development/Interval-function-in-Qlik-Sense/m-p/2518120#M106045 <P>Hi, 3.77 is the correct value, isn't? If you want to reduce to full days you can use Sum(Floor(DUR)) to reduce each value to the lowest integer, or Floor(Sum(DUR)) to reduce the result</P> Sun, 18 May 2025 07:03:54 GMT https://community.qlik.com/t5/App-Development/Interval-function-in-Qlik-Sense/m-p/2518120#M106045 rubenmarin 2025-05-18T07:03:54Z