Chart accumulation not making sense

[#1]

I have a chart that suddenly is not showing the correct amount for the last "bar" in full accumulation mode. It would seem that the count on the last bar should be 132 since the second to last is 130, and the non-accumulation chart shows that the last one has a count of 2.

Is my assumption correct? Am I missing something maybe?

This is in Qlikview 9.

[kji]

I think unchecking "Suppress Zero-Values" on the presentation tab of chart properties will give you what you want.

[#3]

I am assuming that the red part of the bar does not exist in September, therefor it can not sum it as it has no association with September. Instead of checking full accumulation try using rangesum(above(sum(field),0,rowno(total))

[#4]

The various colors are just different dimensions of the data.

The expression itself is =count(ItemNumbers)

And there are different ItemTypes like A, B, C, D.

[#5]

Johan,

Thank you for the suggestion, unforunately this did not work.

[#6]

ok, still give my idea a try, use  rangecount(above(count(ItemNumbers),0,rowno(total))

As I said, then dimension that is causing the red part of the bar probably does not exist in September, so it is no longer included in the full accumulation. I bet if you mentally add this red value to the last bar you get the expected result?

Edit: I am not sure if the rangecount will work across multiple dimensions, you will need to test to see if this is even possible.

[#7]

Hi Marc,

Your assumption is correct. I tested it out by removing the "ItemType" dimension from the chart and it does full accumulation correctly. So, the type is definitely contributing.

I tried your suggestion and set my expresstion to your formula. The results do not seem quite right, though.

[#8]

I had that expression a bit wrong. Try this:

rangesum(above(count(ItemNumbers),0,rowno(total))

set it to no accumulate

[#9]

Hi Marc,

Unfortunately that did not work, either.

[#10]

can you post a sample?