Expressions: full accumulation

Wed, 03 Sep 2014 09:44:35 GMT

Good morning,

I have a doubt in one expression. I have a temporary line chart with weeks in the axe.

With one expresión, sum(Passengers) the full accumulation Works. But if i want to do something like " Revenue/ Passengers" it does not work, because is adding every week the "Rvenue per passenger and not reflecting the cummulate revenue / passenger till this date.

For example:

Date	PASSENGER	Passenger full acum	REVENUE	REVENUE Full accumm	Revenue / Passenger No accumulation	revenue/passenger Full accumulation	revenue/passenger what i want
20/06/2014	123	123	16.163,2	16.163,2	131,6	131,6	131,56
27/06/2014	127	250	16.264,6	32.427,7	128,3	259,9	129,92
04/07/2014	121	371	16.365,6	48.793,3	135,0	394,9	131,57
11/07/2014	130	501	16.471,4	65.264,7	126,4	521,2	130,22
18/07/2014	130	631	16.577,5	81.842,2	127,4	648,7	129,65
25/07/2014	131	762	16.683,3	98.525,5	127,8	776,5	129,33
01/08/2014	120	882	16.783,6	115.309,1	139,8	916,2	130,75
08/08/2014	111	993	16.882,0	132.191,2	152,3	1.068,5	133,15
15/08/2014	102	1095	16.974,6	149.165,8	165,8	1.234,3	136,20
22/08/2014	94	1189	17.060,5	166.226,3	181,2	1.415,5	139,77
29/08/2014	96	1285	17.142,4	183.368,7	179,5	1.595,0	142,72
05/09/2014	94	1379	17.218,6	200.587,3	182,5	1.777,5	145,44
--	--	--	--	--	--	WRONG	RIGHT

Can someone helpme with this?

Thanks a lot!

BElén

topic Expressions: full accumulation in QlikView

Expressions: full accumulation