topic Re: Accumulation Chart in QlikView

Accumulation Chart

Fri, 12 Jun 2015 16:16:54 GMT

I am attempting to do an accumulation chart of our Freight Costs YTD and LYTD. The LYTD is working great... but with the YTD I only want to see the chart up to the Previous Month.

Currently - it is adding "0" freight costs so my chart flat lines. This is causing my trend line to be inaccurate based on YTD trends.

Re: Accumulation Chart

sunny_talwar — Fri, 12 Jun 2015 16:20:16 GMT

I am assuming you are using two expressions. For the expression which is adding bars for future month, you can do something like this:

If(Sum(Value) <> 0, thenAccumulateExpression)

Re: Accumulation Chart

Fri, 12 Jun 2015 16:29:04 GMT

I have added that to my my formula. But still getting the same results.

This is the formula I am using - Sum({<Year= {'2015'}>}FreightCost)

And then I select full accumulation at the bottom.

I think my formula needs to do the accumulation instead of the hot key in the chart properties. But I don't know how to write it.

Re: Accumulation Chart

sunny_talwar — Fri, 12 Jun 2015 16:36:06 GMT

Try this without full accumulation:

=If(Sum({<Year= {'2015'}>}FreightCost) <> 0, RangeSum(Above(Sum({<Year= {'2015'}>}FreightCost), 0, RowNo(TOTAL))))

Re: Accumulation Chart

Fri, 12 Jun 2015 16:38:17 GMT

YOU ARE MY HERO!

Re: Accumulation Chart

sunny_talwar — Fri, 12 Jun 2015 16:38:53 GMT

Hahahaha, I am glad it worked

Sunny