topic Re: Weighted average for every quarter using the last 4 quarters in QlikView

Weighted average for every quarter using the last 4 quarters

ivan_will — Thu, 30 May 2013 13:08:55 GMT

Hi,

please find attached an xls file with an example in it:

the idea is as follows:

for every quarter, for every ID I want to have weighted average Number - so for 31/03/2013 it should be the following:

(Number*daysInQuarter (31/03/2013) +

Number*daysInQuarter (31/12/2012) +

Number*daysInQuarter (30/09/2012) +

Number*daysInQuarter (30/06/2012)) / (90+92+92+91) = 75

for the previous it should be :

(Number*daysInQuarter (31/12/2012) +

Number*daysInQuarter (30/09/2012) +

Number*daysInQuarter (30/06/2012) +

Number*daysInQuarter (31/03/2012)) / (92+92+91+91) = 65

And I want to have this in the script - the same as the below table. So if you have something similar it would be a help. Thanks!

Thanks in advance!

Gysbert_Wassenaar — Thu, 30 May 2013 13:36:36 GMT

See attached example.

ivan_will — Fri, 31 May 2013 07:03:12 GMT

yes, it works fine, but now another question:

if we have another date with change - let's say 21/03/2013 - number= 77

how to calculate the weighted average in qv script for the quarter/s??

regadrs

ivan_will — Fri, 31 May 2013 12:15:30 GMT