Hide Zero Values in Qlik Sense Line Chart

[WB1]

Hi. I’m using a Vizlib Line Chart and trying to get the BM2 measure line to not display if the value is zero. I’ve seen many forums asking similar questions, none of which have helped. Ex: if (expression>0,expression), Suppress zero values, etc. Please Help!

Here is the expression currently driving BM2 for reference:

if(a_Appropriation='X' and FY='23', (aggr(rangesum( above( sum(a_Planned_Cost),0,rowno())),Month)/12)*1,

if(a_Appropriation=X and FY='22', sum(a_Planned_Cost)*1,

if(a_Appropriation=’Y' and FY='23', (aggr(rangesum( above( sum(a_Planned_Cost),0,rowno())),Month)/12)*1,

if(a_Appropriation='Y' and FY='22', sum(a_Planned_Cost)*1,

if(a_Appropriation='Z' and FY='23', (aggr(rangesum( above( sum(a_Planned_Cost),0,rowno())),Month)/12)*.8,

if(a_Appropriation='Z' and FY='22', (aggr(rangesum( above( sum(a_Planned_Cost),0,rowno())),Month)/12)*.9,

if(a_Appropriation='R' and FY='23', (aggr(rangesum( above( sum(a_Planned_Cost),0,rowno())),Month)/12)*.9,

if(a_Appropriation='R' and FY='22', (aggr(rangesum( above( sum(a_Planned_Cost),0,rowno())),Month)/12)*1,

))))))))

TLDR: I want the BM2 line to not display if one of the above combinations is not met when filtering a_Appropriation and FY.

[Alan_Slaughter]

Hi WB1, can you provide a sample qvf that can be imported, and tested with completed details of what you are trying to accomplish

[cristianj23a]

Hi, to hide the zero values in your graph, go to the "Data Management" option and uncheck "Include zero values".

Regarts.