topic Re: Full accumulation not working in chart? in QlikView

Full accumulation not working in chart?

Wed, 05 Mar 2014 20:17:50 GMT

Hello all,

I have a bar chart where I am trying to show accumulation of application testing status (Red, Amber or Green) over time. I noticed that the December bar was shorter than the November bar; upon review of the underlying data, it appears that if there is a month where a value doesn't exist, it doesn't show the previous month at all. Is there a way to do full accumulation for two dimensions so that I can see the full total at the end of the year? Thanks in advance.

Re: Full accumulation not working in chart?

Wed, 05 Mar 2014 20:52:03 GMT

Hi Lisana,

If you have two or more dimension to get the running total try this formula

rangesum(above(Expression,0,rowno()))

Thanks

Re: Full accumulation not working in chart?

MK_QSL — Wed, 05 Mar 2014 21:47:14 GMT

= RangeSum(Above(SUM(Sales),0,RowNo()))

=RangeSum(ABOVE(TOTAL SUM(Sales), 0, RowNo(TOTAL)))

Make sure that under presentation tab, you have untick the Suppress Zero-Values option

Re: Full accumulation not working in chart?

Thu, 06 Mar 2014 19:51:50 GMT

I've tried both of these, which look fine in a straight table, but when I convert to a chart it doubles, so I end up with twice as many.

Re: Full accumulation not working in chart?

Thu, 06 Mar 2014 20:01:36 GMT

Possible to attach a sample