A tricky Question relate to aggr

Wed, 10 Nov 2010 18:21:32 GMT

Hi everyone,

I would like to do the following calculation with 2 fields (Date and Price)

e.g. Date Price

Date	Price	Average Price	Average of Average price
Jul-01	1
Aug-01	2	1.5
Sep-01	3	2	1.75
Oct-01	4	2.5	2
Nov-01	5	3	2.25
Dec-01	6	3.5	2.5
Jan-02	7	4	2.75
Feb-02	8	4.5	3
Mar-02	9	5	3.25

e.g. In Nov-01,

Average price = (1+2+3+4+5)/5 = 3

Average of Average price = (1.5+2+2.5+3)/4 = 2.25

My problem is that: I want one figure 3.25 (the yellow one). How can write the formula?

That is, instead of using a pivot table for so many row, I want to get the figure of 3.25 directly.

Date	Average of Average price
Mar-02	3.25

Any thought?

Or, it will be great if there is anyone can help to tell me:

In Script: How can I get the sum/avg/stdev of increasing time periods?

That, in Nov 01, I get the sum of price from the beginning up to Nov 01 only (Dec 01 data existing, but I don't want to include it or any data after that date)

Many thanks,

Ivan

topic A tricky Question relate to aggr in QlikView

A tricky Question relate to aggr