topic Line chart issue in QlikView

Line chart issue

Sat, 18 Jun 2011 07:46:16 GMT

I have a line chart with X axis as calendar months and Y axis as Amount. there are 2 facts, budget amount and actual amount.

I have the budget for the entire year so the line for budget is displayed for the entire year cummulatively. But the actual amount is still the month of May.

So the line for actual amount goes up till that month and the corrosponding cumulated amount but after that goes flat till the last month.

I dont want that to happen. The actual amount line should be only till the month and should not extend flat till the last month.

Please let me know how this can be done.

Re: Line chart issue

Sat, 18 Jun 2011 08:30:32 GMT

Laxmikantm,

Check out the attached application. I believe your are doing the accumulation using the "Full Accumulation" option.

But you could do this with the combination of RangeSum() and Above() functions.

Your expression should be as below.

if(aggr(sum(Sales),Date)>0,Rangesum(above(Sum (Sales),0,rowno())))

- Sridhar

Line chart issue

Mon, 20 Jun 2011 08:04:25 GMT

Thanks Sridhar for help.

Line chart issue

Mon, 20 Jun 2011 08:58:30 GMT

Good One Shridhar sir..................

I like this solution.....

Shridhar can u pls send me any example qvw for rangesum ,rangeavg , and peak function etc.........

Waiting for your reply......

pls mail me @

dushyant.ntpc@gmail.com

Dushyant

Re: Line chart issue

Mon, 20 Jun 2011 09:15:38 GMT

Dushyant,

I don't have any particular application for rangesum ,rangeavg and peak functions as of now. But all these functions are been discussed on the forum many times. Start searching this forum you would get many examples.

- Sridhar