7 Replies Latest reply: Apr 19, 2016 11:36 AM by R L

# Use full accumulation in a calculation

Hi Experts,

New to Qlikview. I wanted to use running totals using full accumulation based on Dimensions and use this column in another column expression but its using the original values. Based on some suggestions from the community I used RangeSum but it's not working as expected.

[Cum Rec Qty] = Rangesum(above(total Sum(rec_qty),0,rowno(total)))

Please see the screenshot. [Cum Rec Qty] should be running total of Receipts group by <cc_edate, plant, material> that is correctly calculated in column [CRqty] with Full Accumulation. I want to use [Cum Rec Qty] in another expression.

RL

• ###### Re: Use full accumulation in a calculation

Are you sure that accumulated column used the expression you posted, I think it should work.

Could you post a sample

• ###### Re: Use full accumulation in a calculation

In the sort tab for the first dimension of your chart add the sort expression as below and try

=Aggr(Rank(TOTAL Sum(rec_qty)),cc_edate,plant,material)

• ###### Re: Use full accumulation in a calculation

Find a document attached observe the expressions and sort tab in the second table

• ###### Re: Use full accumulation in a calculation

If you need to refer this calculation in the same chart, you could simply use it's label '[Cum Rec Qty]' to refer it. Like:

= [Cum Rec Qty] * 100  , should work fine. However, if you are looking to refer it in other object, you would probably have to use complex expression with Aggr().

• ###### Re: Use full accumulation in a calculation

Thanks Kumar and Tresesco. You suggestions didn't work. I wanted to use expression with accumulation in anothor expression. Please have a look at my example carefully. If I use full accumulation property of the expression [CRqty], I cannot use that in another expression. [Cum Rec Qty] has no accumulation but the expression is not working as expected.

I am expecting [Cum Rec Qty] with no accumulation show values same as [CRqty].

Thanks,

RL

• ###### Re: Use full accumulation in a calculation

Would it be possible to share you application? Also are you using QV12?

• ###### Re: Use full accumulation in a calculation

I am using V11.20 SR12

Please find the application...It's a wip document. !