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: 
maahivee
Contributor III
Contributor III

Accumulation Not working for Calculating other columns

Hello Guys - I have a simple requirement here, But for some reason it is not working..

In a straight table, i have columns  added picks, completed picks, which are regular calculations based on data from tables.

After that i have Begin, added picks cumulative and completed picks cumulative which are same calculations as above but i am giving "full accumulation" for these 3 columns.

And then i have # of Picks which is basically "begin + added picks cumulative - completed picks cumulative".

So when i am doing this # of picks column calculation based on the Full Accumulation columns, I would assume it showing results based on Full accumulation value for that row instead showing result based on the actual value..

Is there any thing i am missing here. or doing anything wrong. Please see the attached sheet for more data.

23 Replies
maahivee
Contributor III
Contributor III
Author

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

Clever_Anjos
Employee
Employee

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

sunny_talwar

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
Contributor III
Contributor III
Author

Please find the attached QVW with my actual data.

Clever_Anjos
Employee
Employee

Yes, fixed as you suggested, stalwar1

Clever_Anjos
Employee
Employee

Do you really need that 2nd dimension?

Clever_Anjos
Employee
Employee

PFA

sunny_talwar

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

maahivee
Contributor III
Contributor III
Author

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
Contributor III
Contributor III
Author

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.