topic Re: Range Average in QlikView

Range Average

shamitshah — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have the following expression to calculate the 3 day average but getting incorrect results for certain dates:

sum( aggr( RangeAvg(above( sum(Stock1),0,3) ),RecordDate))

The average for 3 Dec 2015 should be (5+7+7)/3 = 6.33

The raw data has missing dates, and I have generated those dates to be included in the above table.

Missing dates were 3,4,6,8,9,11 &12

Not sure whether that would be the cause.

Any ideas?

Thanks

Shamit

sunny_talwar — Wed, 25 May 2016 10:08:41 GMT

Can you check what you get for this:

RangeSum(above( sum(Stock1),0,3))

Kushal_Chawda — Wed, 25 May 2016 10:11:12 GMT

try this

RangeAvg(above(total sum(Stock1),0,3) )

shamitshah — Wed, 25 May 2016 10:15:22 GMT

Hi Sunny,

That's give the running 3 day total.

Regards

Shamit

shamitshah — Wed, 25 May 2016 10:16:18 GMT

Hi Kushal,

That's gives the correct answer.

Thanks

Shamit

sunny_talwar — Wed, 25 May 2016 10:19:08 GMT

Ya that what I wanted to check that if you were getting the totals to be correct or not. But I guess adding the TOTAL did the job for you

Kushal_Chawda — Wed, 25 May 2016 10:22:37 GMT

That's gr8

Kushal_Chawda — Wed, 25 May 2016 10:32:54 GMT

Total solves many set analysis issues also stalwar1‌