RangeSum does not start at zero

[Anonymous]

Hello --

I have the following chart to accumulate budgetary/actual/forecasted sales data. As you can see in the chart, the accumulation does not start at 0. This is a very specific thing that the users are demanding. How do I make this start at 0??

This is my expression:

(RangeSum(Above(Sum({<GL_REVENUE_QUARTER=p(QUARTER),GL_REVENUE_YEAR=p(YEAR),GL_REVENUE_MONTH=p(MONTH),GL_VALUE_STREAM=p(VALUESTREAM)>}  GL_BUDGET),0,RowNo())))

I am using a date island table to filter multiple graphs dates using a single filter.

I have tried unchecking supress zero values, etc. It makes no difference.

[Anonymous]

The sum of all rows should be the absolute total.

So, each month should total for that month's budget but the top right end of the line should end up being the sum of all rows. Make sense?

Thanks!

[Clever_Anjos]

It´s ok, I get it, but what´s the 'budget of January'? 8006080? 8006080/3?

And Feb? 8006080/3 + 8006080/3?

[Anonymous]

The budget for each month is actually just the sum of all rows that have that month.

So, in the data table these rows all sum to the total budget for January:

[Clever_Anjos]

I understand, I´ve done without other dimenions but month.

If Jan´s budget is the sum() of values >0, how could be = 0?

[Anonymous]

Haha - I had the same "discussion" with the users who are demanding this.

They realize that January has a value - but basically they want the line to extend down to 0 to start.

So, it'll start at the bottom left and then the first dimension label for January should have exactly what it has now.

Very silly I know - but they're very adamant that they need it to look this way to match historical reports we're converting into Qlik.

Thanks!

[Clever_Anjos]

I understand, I´ve done without other dimenions but month.

If Jan´s budget is the sum() of values >0, how could be = 0?

[Anonymous]

There's no way to force the line to start at a zero point and extend from there?

[Clever_Anjos]

I don´t think so, because you want to "start on zero" having a "non-zero value"

[Anonymous]

Could I somehow inject a row of bogus 0 data in the load script?

Thanks!

[Clever_Anjos]

Let me test an idea, posting in a few minutes