easy kombination accumulation and aggregation

[#1]

Hello,

my first steps with qlikview ...

I m searching the accumulated value per produkt / period

example last line:

Produkt C 8/1997 = 90

Thanks for hints or solution

regards

rl

Year	Month	Produkt	Value	aggr Value Produkt/Time
				??
1994	1	A	50	50
1994	10	A	100	150
1994	12	A	50	200
1994	2	B	1	1
1994	10	B	2	3
1994	14	B	3	6
1994	1	C	30	30
1996	6	C	20	50
1997	8	C	40	90

[#2]

Create a chart of the type Simple Table. Use the following dimensions:

• Product

• =$(=Max(Month)) & "/" & $(=Max(Year))

And the following expression:

• Sum(Value)

I hope this solves your problem

Good luck.

[#3]

Thanks for the fast Response,

but in that Way I get only the total Value per Product.

We need the accumulated Value per Product and Period:

Periode - Produkt - Value

1994/01 - A - 50

1994/10 - A - 150

...

1996/6 - C - 50

1997/12 - C - 90

Regards

rl

[#4]

ok, its not easy...

[johnw]

One approach is to combine Year and Month into one field, YearMonth. Then the above() function will refer to values within the same product, allowing you to use it to do an accumulation.

[#6]

thanks for response,

but I cant open the example

[#7]

Your Accumulation column would have the below expression

rangesum(sum(Value),above(Accumulation))