topic Re: Chart accumulation not making sense in QlikView

Chart accumulation not making sense

Wed, 05 Sep 2012 13:16:48 GMT

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.

Re: Chart accumulation not making sense

kji — Wed, 05 Sep 2012 13:46:01 GMT

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

Re: Chart accumulation not making sense

Wed, 05 Sep 2012 13:52:06 GMT

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))

Re: Chart accumulation not making sense

Wed, 05 Sep 2012 13:57:24 GMT

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.

Re: Chart accumulation not making sense

Wed, 05 Sep 2012 13:57:52 GMT

Johan,

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

Re: Chart accumulation not making sense

Wed, 05 Sep 2012 13:59:44 GMT

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.

Re: Chart accumulation not making sense

Wed, 05 Sep 2012 14:04:35 GMT

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.

Re: Chart accumulation not making sense

Wed, 05 Sep 2012 14:19:05 GMT

I had that expression a bit wrong. Try this:

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

set it to no accumulate

Re: Chart accumulation not making sense

Wed, 05 Sep 2012 14:35:33 GMT

Hi Marc,

Unfortunately that did not work, either.

Re: Chart accumulation not making sense

Wed, 05 Sep 2012 15:01:52 GMT

can you post a sample?

Re: Chart accumulation not making sense

whiteline — Wed, 05 Sep 2012 16:01:41 GMT

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

Re: Chart accumulation not making sense

Wed, 05 Sep 2012 17:41:42 GMT

Sorry I cannot post a sample as this is based on sensitive production data.

Re: Chart accumulation not making sense

whiteline — Wed, 05 Sep 2012 17:59:39 GMT

paste it with sample data.

Re: Chart accumulation not making sense

Wed, 05 Sep 2012 18:00:46 GMT

Or you can scramble your data from the document properties menu/scrambling

Re: Chart accumulation not making sense

Wed, 05 Sep 2012 18:32:04 GMT

Thank you for letting me know that trick!

Here is the scrambled QVW still showing the problem.

Re: Chart accumulation not making sense

whiteline — Thu, 06 Sep 2012 05:52:08 GMT

In this case you can't do it with inter-record functions or with builtin accumulation.

Use the solution from this thread (the last one from John):

http://community.qlik.com/message/88613#88613