Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

RangeSum does not start at zero

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.

1 Solution

Accepted Solutions
27 Replies
Clever_Anjos
Employee
Employee

Would you mind sharing a sample of your application?

Preparing examples for Upload - Reduction and Data Scrambling

Clever_Anjos
Employee
Employee

Are you sure that budget at january is 0?

Anonymous
Not applicable
Author

Hi Clever --

No, there is actual budgetary data for January - but they want the chart line to start at zero.

Thanks!

Anonymous
Not applicable
Author

Attached is a scrambled sample of the particular section of the app.

Clever_Anjos
Employee
Employee

Try this, lightly different

(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),1,RowNo())))

Anonymous
Not applicable
Author

Hi Clever --

Unfortunately, this did not do it. It moved the line to the right:

Clever_Anjos
Employee
Employee

Because, Jan = 0, right?

Uncheck "Supress Zero - Values" into Presentation tab

Anonymous
Not applicable
Author

Hi Clever --

This worked but now the accumulation does not total to the true total. How can I get around that?

Thanks!

Clever_Anjos
Employee
Employee

Well, what´s the 'true total'?

As I can see you have BUDGET for each quarter, but wants to see for each month.

What values you want to see on each month?

Capturar.PNG