Moving average per date (period +/- 3 day) without date in dimension

Anonymous — Fri, 05 Oct 2018 02:35:09 GMT

Hello!

I'm trying to calculate the average daily sales (including +/- 3 days)

In Excel it looks like this:

For example: AvgSales-+3 for 7.10.2018 = average sales from 4.10.2018 till 10.10.2018

In qlik i'm calculated this by expression:

RangeAvg(

Above(Sum(Aggr(Sum(Sales),DateID)),0,4),

Below(Sum(Aggr(Sum(Sales),DateID)),1,3)

)

Help me please calculate this sum of average values without a date in the dimension?

Re: Moving average per date (period +/- 3 day) without date in dimension

sunny_talwar — Fri, 05 Oct 2018 14:40:43 GMT

If date is not a dimension... then is this based on a selection?

Anonymous — Fri, 05 Oct 2018 17:28:01 GMT

I need to get the amount of some average for the period.

I'm trying to calculate lost sales.