topic AW:Re: easy kombination accumulation and aggregation in QlikView

easy kombination accumulation and aggregation

Tue, 20 Apr 2010 10:59:58 GMT

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

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

Tue, 20 Apr 2010 13:06:10 GMT

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

Tue, 20 Apr 2010 14:11:47 GMT

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

AW:Re: easy kombination accumulation and aggregation

Tue, 20 Apr 2010 15:48:05 GMT

ok, its not easy...

AW:Re: easy kombination accumulation and aggregation

johnw — Wed, 21 Apr 2010 00:37:48 GMT

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

Fri, 23 Apr 2010 09:53:32 GMT

thanks for response,

but I cant open the example

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

Fri, 23 Apr 2010 14:11:59 GMT

Your Accumulation column would have the below expression

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