topic Accumulated Column in QlikView

Accumulated Column

martino — Wed, 17 Aug 2011 10:07:58 GMT

By using "Above" in a formula as shown here:

Sum(Sales) + if (rowNo()=1,0, Above([Column Name]))

I have created an Accumulated column

It works perfectly as long i only have 1 Dimension column, but when I have 2 or more dimension columns I can't get the the formula to work.

Does anyone have som insight on this?

Best regards

Martin

Accumulated Column

kaushiknsolanki — Wed, 17 Aug 2011 10:19:42 GMT

Hi,

Try this.

Go to expression and click on the expression for which you want accumulated value and select the Full Accumulation at the left bottom corner.

Regards,

Kaushik Solanki

Accumulated Column

martino — Thu, 18 Aug 2011 09:41:51 GMT

Hi Kaushik,

Thanks for your suggestion, but unfortunately it is not good enougt to use the "Full Accumulation" function under properties as I have a colunm to the right of the Accumulated column that validates the accumulated value and based on the value shows an A, B or C. That does not work when I use the "Full Accumulation" function.

/Martin