6 Replies Latest reply: Apr 23, 2010 10:11 AM by Lee Alderdice

# easy kombination accumulation and aggregation

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
• ###### easy kombination accumulation and aggregation

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.

• ###### AW:Re: easy kombination accumulation and aggregation

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

• ###### AW:Re: easy kombination accumulation and aggregation

ok, its not easy...

• ###### AW:Re: easy kombination accumulation and aggregation

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.

• ###### AW:Re: AW:Re: easy kombination accumulation and aggregation

thanks for response,

but I cant open the example

• ###### AW:Re: AW:Re: easy kombination accumulation and aggregation

Your Accumulation column would have the below expression

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