Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
maahivee
New Contributor III

Re: Accumulation Not working for Calculating other columns

# of Picks =  "begin + added picks cumulative - completed picks cumulative".

Employee
Employee

Re: Accumulation Not working for Calculating other columns

This should work

Rangesum(

Above(Count({<StatusType={'Begin'}>}TransactionAmt),0, rowno()),

-Above(Count({<StatusType={'Added'}>}TransactionAmt),0, rowno()),

Above(Count({<StatusType={'Completed'}>}TransactionAmt),,0 rowno())

)

If doesn´t please share a sample of your qvw Preparing examples for Upload - Reduction and Data Scrambling

Re: Accumulation Not working for Calculating other columns

This you mean?

Rangesum(

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

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

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

maahivee
New Contributor III

Re: Accumulation Not working for Calculating other columns

Please find the attached QVW with my actual data.

Employee
Employee

Re: Accumulation Not working for Calculating other columns

Yes, fixed as you suggested, stalwar1

Employee
Employee

Re: Accumulation Not working for Calculating other columns

Do you really need that 2nd dimension?

Employee
Employee

Re: Accumulation Not working for Calculating other columns

PFA

Re: Accumulation Not working for Calculating other columns

Can you try this:

Rangesum(

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

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

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


Capture.PNG

Highlighted
maahivee
New Contributor III

Re: Accumulation Not working for Calculating other columns

Hello Anjos - I dont know why that same expression in that QVW you attached is not working in my actual QVW.

Giving the same numbers as before.

maahivee
New Contributor III

Re: Accumulation Not working for Calculating other columns

Hello Sunny - If we look at hour 9 it should be 101+262-131 = 232 it is instead 332

hour 10 also  101+323-134 = 290 it is instead 421.