topic Cumulative values over the second dimension in QlikView

Cumulative values over the second dimension

Wed, 13 Jun 2012 14:03:19 GMT

Hello everyone,

I am facing a problem in a curve chart with 2 dimensions when I want to have cumulative values over the second dimension.

Let me explain :

Dim1	Dim2	Value1	Value2
A	0	10	10
B	0	5	10+5 = 15
B	1	2	2
C	0	8	10+5+8 = 23
C	1	20	2+20 = 22
C	2	25	25

I tried the RangeSum/Above stuff but it only works if I want cumulative values over the first dimension. Moreover, I can't swap the dimensions because of the curve chart.

Thanks in advance for your help !

Damien

Re: Cumulative values over the second dimension

jonathandienst — Wed, 13 Jun 2012 14:36:07 GMT

Have you tried Above(TOTAL ....)? This will ignore the second dimension.

Regards

Jonathan

Re: Cumulative values over the second dimension

Wed, 13 Jun 2012 16:49:12 GMT

Hi Jonathan,

Using Above(TOTAL) , I get :

Dim1	Dim2	Value1	Value2
A	0	10	10
B	0	5	10+5 = 15
B	1	2	10+5+2 = 17
C	0	8	10+5+2+8 =35
C	1	20	10+5+2+8+20 = 55
C	2	25	10+5+2+8+20+25=80

Which is not exactly what I want. I need to keep accumulating datas over the second dimension.

Damien

Re: Cumulative values over the second dimension

jonathandienst — Thu, 14 Jun 2012 06:31:14 GMT

Damien

I missed that point in your original post. Will have to think about it...

Jonathan

Re: Cumulative values over the second dimension

jonathandienst — Thu, 14 Jun 2012 07:45:37 GMT

Damien

Here's my best shot. I used a Pick expression to accumulate for each value of Dim2. The pick expression is compted dynamically from a unique list of Dim2 values.

Have a look at the attached - I think it does what you need.

Regards

Jonathan