topic Problem with Full Accumulation in QlikView

Problem with Full Accumulation

Wed, 01 Jul 2015 18:51:50 GMT

I'm having trouble getting my chart to display cumulative values. Currently I have three expressions,

1) ACTUALS: which contains values for months 1-4,

2) FORECASTS: which contains values for months 5-12, and

3) PLAN: which contains values for months 1-12.

I want to show the cumulative values for ACTUALS, but have it include the FORECAST values after month 5.

Example Chart: Without Full Accumulation

Example Chart: With Full Accumulation

Every time I use full accumulation it flat lines ACTUALS after APR. How can I incorporate all three expressions so the chart reads something like the following.

Re: Problem with Full Accumulation

marcus_sommer — Wed, 01 Jul 2015 19:28:35 GMT

I'm not sure if you get it with the inbuilt accumulation. I think you will need more an direct cummulative-expression with rangesum() and above() like: Re: Rangesum Above not working

- Marcus

Re: Problem with Full Accumulation

sunny_talwar — Wed, 01 Jul 2015 19:57:57 GMT

Can you share a sample and provide a expected output.

Based,

Sunny

Re: Problem with Full Accumulation

Wed, 01 Jul 2015 20:19:19 GMT

Attached is some example data that I am working with. I am using three expressions within QlikView,

1) Actuals: Sum({1<[Metric]={'Metric 1'}>} [Actual])

2) Forecast: Sum({1<[Metric]={'Metric 1'}>} [Forecast])

3) Plan: Sum({1<[Metric]={'Metric 1'}>} [Plan])

I have the actuals to show either green if better than plan, or red if worse. For forecasts, I want them conditionally grey. The end result should be something similar to the following.

Re: Problem with Full Accumulation

Mon, 06 Jul 2015 14:03:27 GMT

BUMP