topic Re: Full Accumulation in QlikView

Full Accumulation

Tue, 06 Mar 2012 23:05:04 GMT

Hi,

Is there a way to reverse the order of full accumulation?

Example: Instead of the numbers increasing while scrolling down a table column, they increase while scrolling up.

Full Accumulation

hic — Tue, 06 Mar 2012 23:17:24 GMT

Yes, but it is a little tricky...

First, do not use the radio button. Define it in the Expression instead.

If your expression is "RangeSum(below(Acc), Sum(x))" and you label the expression "Acc", then you will have it. Well, given that your field that you want to sum is called "x"...

HIC

Re: Full Accumulation

CELAMBARASAN — Wed, 07 Mar 2012 04:36:21 GMT

Hi,

Uncheck the Full Accumulation option.instead of going with the option you need to do this in expression.

Use Expression as RangeSum(Below([This Expression label]),Sum(Sales))

Celambarasan

Re: Full Accumulation

jagan — Wed, 07 Mar 2012 05:18:50 GMT

Hi,

Uncheck the Full Accumulation option, and use this expression

Sales = RangeSum(below([Sales]), Sum(FieldName))

Where Sales is your expression name.

Regards,

Jagan.

Re: Full Accumulation

Tue, 21 May 2013 03:11:02 GMT

Thanks for this. Has anyone been able to overcome issues with this RangeSum calculation changing the line values when multiple dimensions are showing?

Thanks,