Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
Hi, Try to uncheck Include zero values. In the properties panel click the Add-ons section and then click Data Handling.
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)
Try this:
Sum({$< Demanda={"=Len(Trim([Demanda))>0"} >} Demanda)
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".
Do the same for the other expression. i.e.
Sum({$< Reales={"=Len(Trim([Reales))>0"} >} Reales)
I've tried, but no success (see image below).
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.
=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