Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
jonstokes
Contributor II
Contributor II

Hiding "null values" in line chart with accumulation

Hi there!

I have a "progress towards target" line chart (screenshot attached) which accumulates with the following function:

RangeSum(Above(Sum([Indirect beneficiaries]),0,rowno()))

Although the "target" line should continue to 2020, I'd like the cumulative "indirect beneficiaries" line to stop at the most recently reported quarter.


Does anyone know how this could be achieved? Although this change may seem trivial, I know that users will not look at this for long and I want it to be very clear where we have data and where we don't yet.

Thanks!

Jonathan

1 Solution

Accepted Solutions
sunny_talwar

May be this:

If(Sum([Indirect beneficiaries]) > 0, RangeSum(Above(Sum([Indirect beneficiaries]),0,RowNo())))

View solution in original post

3 Replies
sunny_talwar

May be this:

If(Sum([Indirect beneficiaries]) > 0, RangeSum(Above(Sum([Indirect beneficiaries]),0,RowNo())))

jonstokes
Contributor II
Contributor II
Author

Thanks Sunny, much appreciated! This was a lot simpler than I though it would be!

Jonathan

Not applicable

Hi Sunny,

Thank you very much for your help.

I'm facing a different problem, can you please help me.

I need to show Current Financial Year & Previous Financial Year.

We have data upto Aug 2016. But cumulative values are coming for complete financial year.

Please find the attachment for your reference.

Please let me know how to fix green color line (Current FY) in the chart. It should be displayed only for Jul & Aug.

Capture123.JPG

Thanks in Advance.

Arjun.