Remove Chart Line Drop when value is 0 in the end

[stevegimbrollmt]

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

[tresesco]

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.

[stevegimbrollmt]

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

[shraddha_g]

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

[stevegimbrollmt]

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

[darrell_tobin]

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.