topic Ignore zero values on accumulated line in chart in QlikView

Ignore zero values on accumulated line in chart

Thu, 14 Jan 2016 16:07:08 GMT

Dear community members

Has anyone an idea how I could ignore the datapints from the dark blue line ("Base planning CP"). The goal is to start at zero and directly connect the line to the next available amount. In my datamodel I only have dates + values on the desired datapoints.

Thanks for your help

Date	Value
31.01.2012	0
31.12.2013	51885
28.02.2014	164732
31.12.2016	20084

Nachricht geändert durch Michael Städtler

Re: Ignore zero values on accumulated line in chart

sunny_talwar — Thu, 14 Jan 2016 19:58:19 GMT

May be something like this:

If(YourExpression <> 0, YourExpression)

But you will need a additional if to check for the first 0. May be use the minimum date to allow that to be 0 and everything else becomes null().

Re: Ignore zero values on accumulated line in chart

Fri, 15 Jan 2016 10:06:26 GMT

Thx for your post.

This is not working. The problem is the second expresion in this chart. Whenever it has a datapoint on a given date, it uses this date with value 0 also for the other expression.

Any other ideas?

Re: Ignore zero values on accumulated line in chart

sunny_talwar — Fri, 15 Jan 2016 11:14:04 GMT

May be able to offer better advice if I can have a sample to work with.

Re: Ignore zero values on accumulated line in chart

Fri, 15 Jan 2016 13:05:29 GMT

! added the example with the desired line in my original post.

Re: Ignore zero values on accumulated line in chart

miguelbraga — Fri, 15 Jan 2016 17:05:17 GMT

@This?

Re: Ignore zero values on accumulated line in chart

miguelbraga — Fri, 15 Jan 2016 17:06:16 GMT

Just sets the static min in the axes as:

min(SUM({<KPIID = {20}>} VALUE))

Regards,

Re: Ignore zero values on accumulated line in chart

Sat, 16 Jan 2016 14:26:21 GMT

Thanks Miguel, but this is not the problem.

Please look at the example. The Line for "Base planning CP" should go straight from 0 to the first available data point (62'290,-). Now it goes parallel to the date axix and then to the first data point.

Thanks

Re: Ignore zero values on accumulated line in chart

sunny_talwar — Sat, 16 Jan 2016 18:44:45 GMT

May be this:

If(Sum({<KPIID = {20}>} VALUE) = 0 and DATE <> Date(Min({<KPIID = {20}>}TOTAL DATE)), Null(), RangeSum(Above(Sum({<KPIID = {20}>} VALUE), 0, RowNo())))

Re: Ignore zero values on accumulated line in chart

Sun, 17 Jan 2016 16:17:36 GMT

Works perfectly! Thank you sunindia!

Re: Ignore zero values on accumulated line in chart

sunny_talwar — Sun, 17 Jan 2016 16:43:32 GMT

No problem at all. I am glad we were able to make it work