topic Re: Rangesum on dimension values in QlikView

Rangesum on dimension values

Wed, 27 Aug 2014 08:18:01 GMT

Hi,

I have a table in which I want to accumulate the values. if it was some basic accumulation it would not be a problem, But..

i dont want to accumulate it on the cell above, i want to accumulate it with the cell above that has the same dimension value.

Week	Class	Amount	Cumulative
21	10+	9	9
21	20+	6	6
21	30+	12	12
22	10+	8	17
22	20+	7	13
22	30+	13	25
23	10+	5	22
23	20+	8	25
23	30+	16	41

personally i think i am close to the solution but it needs that last little tweak that I can't figure out.

my expression right now is:

=rangesum(above(sum(Amount),0,rowno(TOTAL<Class>)))

when using the <Class> after TOTAL, the expression fails. but without the <Class> it behaves like normal rangesum which i don't like

Re: Rangesum on dimension values

marcus_sommer — Wed, 27 Aug 2014 09:48:08 GMT

I'm not sure if it could even work but you should rather try to use total and/or set analysis within sum(Amount). I personally would rather choose another chart-design to show the results ...

- Marcus

Re: Rangesum on dimension values

dickelsa — Thu, 28 Aug 2014 19:21:10 GMT

Hello,

I am also looking for the same solution with a similar situation.

Has anyone got an idea?

regards,

Dick

Re: Rangesum on dimension values

Fri, 29 Aug 2014 11:35:46 GMT

I suppose it is not how you normally use the Cumulative function. But i see great potential for end users if this could be realized in some way.

Week	Class	Amount	Cumulative
21	10+	9	9
21	20+	6	6
21	30+	12	12
22	10+	8	17
22	20+	7	13
22	30+	13	25
23	10+	5	22
23	20+	8	25
23	30+	16	41

Week	Class	Amount	Cumulative
21	10+	9	9
21	20+	6	6
21	30+	12	12
22	10+	8	17
22	20+	7	13
22	30+	13	25
23	10+	5	22
23	20+	8	25
23	30+	16	41

Week	Class	Amount	Cumulative
21	10+	9	9
21	20+	6	6
21	30+	12	12
22	10+	8	17
22	20+	7	13
22	30+	13	25
23	10+	5	22
23	20+	8	25
23	30+	16	41