topic How to find the Average Interval between Days? in QlikView

How to find the Average Interval between Days?

mohan_1105 — Fri, 05 May 2017 13:40:36 GMT

Hi,

I wanted to calculate the average interval days between consecutive dates. I found the interval using the following expression,

Interval(Below(date(ORDERDATE)) - date(ORDERDATE),'d')

I tried using the following expression, Aggr(Avg(Interval(Below(date(ORDERDATE)) - date(ORDERDATE),'d')))

it throws me an error in expression saying Below function is not allowed inside aggregation.

I am actually trying to get the table like,

I have attached the sample file for your convenience.

Thanks in advance!!

tresB — Fri, 05 May 2017 14:07:00 GMT

Try like:

Avg(total <Group> Aggr(

Interval(Below(ORDERDATE)-ORDERDATE-1,'D')

,Group,ORDERDATE))

mohan_1105 — Mon, 08 May 2017 07:04:20 GMT

Hi Tresesco,

Thanks for helping me with the expression. It works for good.