Remove points from line plot

[aguitatierra]

I'd like to remove the points after the line. The data plotted is sum(Demanda) and the values are actually NULL for the last three months (see table below). However, when I apply sum I get zeros back. 

Any ideas highly appreciated!! 

[BrunPierre]

Hi, Try to uncheck Include zero values. In the properties panel click the Add-ons section and then click Data Handling.

[aguitatierra]

Many thanks for your reply. Yes, I had already tried that but didn't work. 

Based on other posts (ej. https://community.qlik.com/t5/QlikView-App-Dev/Removing-data-points-from-a-chart/td-p/1148936) I've also tried with multiple expressions in the line of this one, but no luck.

sum({< FlagDemanda = {0} >} Demanda)

[BrunPierre]

Try this:

Sum({$< Demanda={"=Len(Trim([Demanda))>0"} >} Demanda)

[aguitatierra]

Hi, thanks! Yes, it works when I only have one line, but I actually have two. When I introduce the second one, values get plotted even though there is no data for Reales... I have unchecked "Include zero values".

[BrunPierre]

Do the same for the other expression. i.e.

Sum({$< Reales={"=Len(Trim([Reales))>0"} >} Reales)

[aguitatierra]

I've tried, but no success (see image below).

• Reales = Sum({$<Demanda = {"=Len(Trim([Demanda]))>0"}>} Demanda)
• Esperados = Sum({$<DemandaF = {"=Len(Trim([DemandaF]))>0"}>} DemandaF)

Just in case, to clarify that I'd like to remove the Reales line from May onwards, but not the Esperados line. Reales corresponds to real data and Esperados to a future prediction.

[BrunPierre]

=Sum({$<FechaDate={"=Sum({1} Demanda)>0"}>} Demanda)

or

=If(Sum(Demanda) > 0, Sum(Demanda))

or removing zeros in the load script.

If(IsNull(Demanda) or Len(Trim(Demanda)) = 0,Null(), Demanda) as Demanda