Skip to main content
Announcements
You can succeed best and quickest by helping others to succeed. Join the conversation.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem with Full Accumulation

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.

withoutfullaccumulation.png

Example Chart: Without Full Accumulation

withfullaccumulation.png

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.

4 Replies
marcus_sommer
MVP & Luminary
MVP & Luminary

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

sunny_talwar

Can you share a sample and provide a expected output.

Based,

Sunny

Not applicable
Author

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.

example graph.png

Not applicable
Author

BUMP