topic Adding row(1) with previous row(2) in QlikView

Adding row(1) with previous row(2)

Thu, 20 Jun 2013 05:46:23 GMT

Object	10	2	4	8	10
Accumulation	10	12	16	24	34

How can i calculate in this way using pivot table? Both 'Object' and 'Accumulation' are expression. Any suggestions on what expressions to use?

January	February	March	1st quarter
10	11	1	23
10	21	22	---

And, how can i derived in such a way every quarter, the second row will be null?

Gysbert_Wassenaar — Thu, 20 Jun 2013 05:52:38 GMT

Try: rangesum(above(total sum(Object),0,rowno(total)))

depending on the layout of your table you may need to use the before() function instead of above()

Thu, 20 Jun 2013 05:53:39 GMT

RangeSum(Above(sum(Object),0, rowno()))

Thu, 20 Jun 2013 06:03:04 GMT

Thanks for all of your reply. But I'm having 'Bad Field Name(s): Object ' . Sorry that i forgot to state that my object is actually an expression.

Thu, 20 Jun 2013 06:03:30 GMT

see attached file

Try to use Object field in expression

Thu, 20 Jun 2013 06:11:05 GMT

I tried to use the field icon but its still the same. Still having the same error.

priyav24 — Thu, 20 Jun 2013 12:33:41 GMT

PFA..

This is another way of doing the cumulative sum..

Just check the full accumulation