Problem in Calculating Mean

Mon, 28 Jan 2013 18:10:30 GMT

WEEK	GEO	Volume	Mean
1	A	1,108.56	923.51
2	B	2,489.13	1,891.84
3	C	1,351.37	1,025.19
4	A	1,230.70	-
5	B	2,563.97	-
6	C	1,162.73	-
7	A	1,390.05	-
8	B	2,857.79	-
9	C	1,558.26	-
10	A	1,290.58	-
11	B	2,609.77	-
12	C	1,331.18	-

Hi All,

I am trying to calculate the Mean through an expression :

Aggr(Avg(Aggr(Sum({<Product_Id={9},Geo={'Region'}>}Volume),Week,Geo)),Geo)

I need to calculate mean for a period of time for different Regions.

Here A, B, C are Regions.

But I am getting only first 3 values that is for week 1, 2, 3. For Other Weeks , I am getting Null Values. In place of Null Values , the same 3 nos should be repeated across different Regions.

WEEK	GEO	Volume	Mean
1	A	1,108.56	923.51
2	B	2,489.13	1,891.84
3	C	1,351.37	1,025.19
4	A	1,230.70	923.51
5	B	2,563.97	1,891.84
6	C	1,162.73	1,025.19
7	A	1,390.05	923.51
8	B	2,857.79	1,891.84
9	C	1,558.26	1,025.19
10	A	1,290.58	923.51
11	B	2,609.77	1,891.84
12	C	1,331.18	1,025.19

I need to have the result like above table. Kindly Help me.

Re: Problem in Calculating Mean

Gysbert_Wassenaar — Mon, 28 Jan 2013 18:23:46 GMT

Try:

Avg(total <Geo> Aggr(Sum({<Product_Id={9},Geo={'Region'}>}Volume),Week,Geo))

Re: Problem in Calculating Mean

Mon, 28 Jan 2013 18:31:50 GMT

Can you please check my discussion, i really need help. Thanks

Re: Problem in Calculating Mean

Tue, 29 Jan 2013 12:00:50 GMT

Thanks a lot ..... It works

topic Re: Problem in Calculating Mean in QlikView

Problem in Calculating Mean

Re: Problem in Calculating Mean

Re: Problem in Calculating Mean

Re: Problem in Calculating Mean