topic Remove Chart Line Drop when value is 0 in the end in QlikView

Remove Chart Line Drop when value is 0 in the end

stevegimbrollmt — Thu, 03 Nov 2016 11:20:19 GMT

Hi friends,

Does anyone has a proper solution in removing this particular drop and leave it till the previous week where there was the last record.

Thank you

Re: Remove Chart Line Drop when value is 0 in the end

tresB — Thu, 03 Nov 2016 12:43:34 GMT

It seems that - with multiple expressions (lines) it is difficult (if not impossible in qlik sense natively). Had you have single line you could probably control that using an expression like: Sum( {<WeekNum={"=Sum(Sales)>0"}>}Sales)

Assuming your dimension is WeekNum.

Re: Remove Chart Line Drop when value is 0 in the end

stevegimbrollmt — Thu, 03 Nov 2016 18:04:46 GMT

Yeah I know and its so annoying, I might need to get it custom made.. will be checking the library to see if there are any solutions for it.

Thanks mate

Re: Remove Chart Line Drop when value is 0 in the end

shraddha_g — Fri, 04 Nov 2016 03:43:57 GMT

In Add-Ons section -> Data Handling - > uncheck Show Zero values

Re: Remove Chart Line Drop when value is 0 in the end

stevegimbrollmt — Fri, 04 Nov 2016 10:52:10 GMT

I wish it was this easy... no it doesnt work . thanks

Re: Remove Chart Line Drop when value is 0 in the end

darrell_tobin — Wed, 11 Oct 2017 15:24:16 GMT

Qlik is doing this because the 'measure' is returning a value of 0. To fix this we need to replace 0 with null.

Use an if function as in the expression below:

=If(

Sum(Sales) = 0, // where sum(Sales) is you measure

Null(),

Sum(Sales)

)

This expression will replace 0 with null which should stop the line from showing.