Cumulative Bar Chart Multiplying Results?

[#1]

Hello All,

I am trying to create a cumulative bar chart using the expression:

Rangesum

(above(TOTAL count(Product_id), 0, rowno(total)))

It works fine when just selecting one product, however when I select more than one product, it multiplies the result in the chart. Please see the attached picture of product A & D. In reality, product A has only sold 27 for this period, it is D that has sold 1058.

I would expect then for the cumulative total in 2012 to be 1085. Instead it appears to be ~2,200.

I know the problem is in the chart - I have attached the straight table behind this chart and it accumulates just fine.

Also an additional point - I have this chart set to 'no accumulation' since this is what the expression does and when I do set it to 'full accumulation' the results are multiplied further.

Any help would be appreciated! I can't see where this has gone wrong...

Thanks!

M

[#2]

Read this blog.. Hope it will help you to solve.

http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/12/accumulative-sums