topic Re: Accumulation in Pivot table (no acculation over year) in QlikView

Accumulation in Pivot table (no acculation over year)

Thu, 05 Jun 2014 11:15:38 GMT

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

Re: Accumulation in Pivot table (no acculation over year)

Thu, 05 Jun 2014 12:31:58 GMT

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

chris

Re: Accumulation in Pivot table (no acculation over year)

Thu, 05 Jun 2014 12:34:02 GMT

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

Re: Re: Accumulation in Pivot table (no acculation over year)

Fri, 06 Jun 2014 04:51:11 GMT

Hi,

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

Adding a year to expression did not change the results.

Re: Accumulation in Pivot table (no acculation over year)

Tue, 24 Jun 2014 08:08:04 GMT

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