Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Note: You may notice some temporary visual or styling issues in the Community. Our vendor is actively investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sum Value Accumulated

Hi,

I need help with this straight table.

I want sum the column Value and Value_Acum (Full Accumulation) but it does not work (7+28= 14) I need 7+28=35

Attach a document with a example.

Thanks a lot.

1 Solution

Accepted Solutions
m_woolf
Master II
Master II

6 Replies
m_woolf
Master II
Master II

Try setting Value_Acum to no accumulation and then use this expression:

=if(rowno()=1,Value,Value+Above(Value_Acum,1))

Not applicable
Author

Hi mwoolf,

Thanks you for answering, but that not working.

See Screenshot.

Regards

mwoolf.bmp

m_woolf
Master II
Master II

You still have column2 set to accumulate and you still have the same expression in column 2.

Not applicable
Author

To the Field G the result will be 7+ 28 = 35. (28=1+2+3+4+5+6+7)

With you expression 7+13 = 20 it's not correct.

Thanks

m_woolf
Master II
Master II

Here is the qvw

Not applicable
Author

Thanks a lot mwoolf, I see now.