Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
stevegimbrollmt
Creator II
Creator II

Remove Chart Line Drop when value is 0 in the end

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

ChartDrop.jpg

5 Replies
tresesco
MVP
MVP

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
Creator II
Creator II
Author

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
Partner - Master III
Partner - Master III

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

stevegimbrollmt
Creator II
Creator II
Author

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

darrell_tobin
Creator
Creator

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.