Cumulative graph: stop in the max month that have a value

[#1]

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/5126.cumulative-bar-graph.docx:550:0]

First of all, sorry for may english...

I have a bar graph of cumulative sum of budget from January to December. I want the line that represents the real cost (green) to stop in the last month that has valu, ¿how can I do it?

Thanks in advance

[#2 · Accepted solution]

Hi,

try something like this:

load * inline [
month,budget,real
01, 1200, 1000
02, 1100, 600
03, 1000, 900
04, 1400, 1500
05, 1450,
06, 1500,
07, 1300,
08, 1000,
09, 1500,
];

Select "no accumulation" and use expressions:

BUDGET= rangesum(sum(budget),above(Sum(budget),1,12))
REAL = if(sum(real)>0,rangesum(sum(real),above(Sum(real),1,12)))

Alex

[#3]

Great!!! thanks, that's I what I wanted.

Fernando Novoa