Running Avarage per month in a text box

[#1]

Hi,

I've got the following challenge: I want to show a running average, in 1 formula, in a text box.

Rec#	Month	A	B	C	D		D=
1	1	500	510	98,04%	98,04%		C(Rec 1)/Month		=	98,04%	/	1
2	2	523	525	99,62%	98,83%		C(Rec 1:2)/Month		=	197,66%	/	2
3	3	515	527	97,72%	98,46%		C(Rec 1:3)/Month		=	295,38%	/	3
4	4	527	530	99,43%	98,70%		C(Rec 1:4)/Month		=	394,82%	/	4
	Selection :			Result in Text-Box
	1			98,04%
	2			98,83%
	3			98,46%
	4			98,70%

If i select month 2 I want to see 98,83% and when i select month 4 i want to see 98,70%.

Any idea how i can perform this?

Thanks in advance

M

[#2]

Hi

Running averages can be solved with one of the AsOf or flag approaches, have a look at this thread

http://community.qlik.com/forums/p/28966/113027.aspx#113027

Regards

Jürg