Interval function in Qlik Sense

[RajuNatesan]

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.

Below is the data snippet that needs the clarification

Interval function used in Qlik Sense Data Load editor : Interval(TS-1 - TS-2, 'd') as DUR.

When I use SUM(DUR) in table chart, it is showing me 3.77, against 3.

Any suggestions on how to get this issue fixed

[rubenmarin]

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