Average of Interval unexpected result

MattG — Wed, 31 Jan 2024 23:50:39 GMT

In my script I have an interval. Interval(DateTime2 - DateTime1,'mm') as MyInterval to get the minutes between two date times.

This returns the expected value.

If I select just one record, the interval is 63

Sum(MyInterval) = 63 Count(MyInterval)=1 Median(MyInterval) = 63 which is correct.

However avg(MyInterval) = 0.044131944

Why is this output for the average function and how do I have it return the average of my value.

Re: Average of Interval unexpected result

rwunderlich — Thu, 01 Feb 2024 04:49:26 GMT

In Qlik, times are represented as the fraction of a day. 0.5 = noon. So 044131944 * 1440 minutes in a day = 63 minutes. Avg is returning the correct value. You just need to apply the Interval formatting function if you want to see it as minutes

Interval(avg(MyInterval), 'mm')

-Rob

topic Re: Average of Interval unexpected result in App Development

Average of Interval unexpected result

Re: Average of Interval unexpected result