Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
jonstokes
New 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

Tags (2)
1 Solution

Accepted Solutions

Re: Hiding "null values" in line chart with accumulation

May be this:

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

3 Replies

Re: Hiding "null values" in line chart with accumulation

May be this:

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

jonstokes
New Contributor II

Re: Hiding "null values" in line chart with accumulation

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

Jonathan

Not applicable

Re: Hiding "null values" in line chart with accumulation

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.