Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
phase2medical
New Contributor III

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.

Tags (2)
1 Solution

Accepted Solutions
Employee
Employee

Re: RangeSum does not start at zero

27 Replies
Employee
Employee

Re: RangeSum does not start at zero

Would you mind sharing a sample of your application?

Preparing examples for Upload - Reduction and Data Scrambling

Employee
Employee

Re: RangeSum does not start at zero

Are you sure that budget at january is 0?

phase2medical
New Contributor III

Re: RangeSum does not start at zero

Hi Clever --

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

Thanks!

phase2medical
New Contributor III

Re: RangeSum does not start at zero

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

Employee
Employee

Re: RangeSum does not start at zero

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())))

phase2medical
New Contributor III

Re: RangeSum does not start at zero

Hi Clever --

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

Employee
Employee

Re: RangeSum does not start at zero

Because, Jan = 0, right?

Uncheck "Supress Zero - Values" into Presentation tab

phase2medical
New Contributor III

Re: RangeSum does not start at zero

Hi Clever --

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

Thanks!

Employee
Employee

Re: RangeSum does not start at zero

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