Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Accumulation in Pivot table (no acculation over year)

Hi all,

I have Pivot table with horizontal dimensions Year & Month and I´d like to calculate accumulated sums. Actually I did succeed with calculation but the problem is how "end" accumulation to yearend (for example Dec-2013)? In other words, when year changes, accumulation should start from Jan-2014, not continue from Dec-2013?

My Expression:

RangeSum(Before(TOTAL sum({<Month={$(=vMinMonth)},CashPeriod={1},CashCalcMark={1} >}CashFlowAmount),0, ColumnNo(TOTAL)))+

RangeSum(Before(TOTAL sum({<Month={$(=vMinMonth)},CashPeriod={1},CashCalcMark={2} >}CashFlowAmount*-1),0, ColumnNo(TOTAL)))+

RangeSum(Before(TOTAL sum({<CashPeriod={2},CashCalcMark={1} >}CashFlowAmount),0, ColumnNo(TOTAL)))+

RangeSum(Before(TOTAL sum({<CashPeriod={2},CashCalcMark={2} >}CashFlowAmount*-1),0, ColumnNo(TOTAL)))

Regards,

Suvi

4 Replies
Not applicable
Author

Hi

may be you can add year={year}  in your expression

chris

Not applicable
Author

Can you share your qvw? It will be easier to answer then.

Not applicable
Author

Hi,

Here is example QVW, sorry for some lines are in Finnish.

Adding a year to expression did not change the results.

Not applicable
Author

Hi, I still have this over year accumulation problem, can someone help me?