topic Sum Value Accumulated in QlikView

Sum Value Accumulated

Wed, 31 Aug 2011 14:37:54 GMT

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.

m_woolf — Wed, 31 Aug 2011 14:53:27 GMT

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

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

Wed, 31 Aug 2011 15:07:31 GMT

Hi mwoolf,

Thanks you for answering, but that not working.

See Screenshot.

Regards

m_woolf — Wed, 31 Aug 2011 15:11:07 GMT

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

Wed, 31 Aug 2011 15:17:57 GMT

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 — Wed, 31 Aug 2011 15:22:00 GMT

Here is the qvw

Wed, 31 Aug 2011 15:42:03 GMT

Thanks a lot mwoolf, I see now.