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

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

Thu, 15 Apr 2010 22:00:39 GMT

[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

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

Fri, 16 Apr 2010 15:49:00 GMT

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

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

Fri, 16 Apr 2010 16:08:49 GMT

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

Fernando Novoa