Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Re: Accumulation Not working for Calculating other columns

Try this:

Rangesum(Above(TOTAL Count({<StatusType={'Begin'}>}TransactionAmt), 0, RowNo(TOTAL)),

  Above(TOTAL Count({<StatusType={'Added'}>}TransactionAmt), 0, RowNo(TOTAL)))

-RangeSum(Above(TOTAL Count({<StatusType={'Completed'}>}TransactionAmt), 0, RowNo(TOTAL)))


Capture.PNG



Employee
Employee

Re: Accumulation Not working for Calculating other columns

Because your table has 2 dimensions (one of them is hidden)

Highlighted
maahivee
New Contributor III

Re: Accumulation Not working for Calculating other columns

Thank you Sunny and Anjos , your effort and help is highly appreciated.

Re: Accumulation Not working for Calculating other columns

No problem at all. We are glad we were able to help