topic Full accumulate in Trellis Chart in QlikView

Full accumulate in Trellis Chart

Mon, 19 Apr 2010 10:45:37 GMT

Hi Qliks!

I have problems with performing "full accumulation" in the Trellis chart. Please see the enclosed example file.

The application shows the data presented in two trellis charts. In the dataset I have included the accumulated value which is presented in the chart as "Truth".

One chart uses the "Full accumulate" function
The other chart calculates the accumulation via a rangesum() formula

But - neither of the charts gives me the right accumulated value - only the second chart for category "a" using the rangesum() seems to match...

Thanks for your always valuable feedback!

Full accumulate in Trellis Chart

Oleg_Troyansky — Tue, 20 Apr 2010 01:51:50 GMT

Lars,

it looks like the "Full Accumulation" doesn't work well with Trellis - I think it deserves to be reported as a bug.

On the other side, your solution with Rangesum() will work fine, just remove the "Full Accumulation" setting from the expression, and you'll see that the green and the red lines become identical.

cheers,

Full accumulate in Trellis Chart

nathanfurby — Fri, 01 Oct 2010 15:48:08 GMT

FYI - QlikView support have told me this will not be fixed as it is WAD (Works as Designed). Seems ridiculous to me.

Full accumulate in Trellis Chart

Fri, 01 Oct 2010 16:39:51 GMT

There seems to be a lot of bugs with Trellis charts. Upgrading to SR5 from SR2 fixed a number of them but others still remain. It's a shame as trellis charts can be very effective.

Full accumulate in Trellis Chart

Wed, 01 Jun 2011 11:35:40 GMT

Works as Designed? Seriously?

Any idea if they will change? i'm stuck with this... any tips?

Thanks.