Hide Zero value line chart

[ahmar811]

Hi

Experts,

Please find below screenshot where my chart shows cumulative Sales CY (Orange Line), PY(Black Line), Budget (Light Orange Line) using rangesum and above function in Qliksense.

But the problem is CY(Orange Line) Sales we have data till September so, I want to hide CY line after September.

Regards

Ahmar

[Chanty4u · Accepted solution]

goto data handling tab

un tick suppress null value.   or

conditional :

your expression>0

[ahmar811]

Thanks, Chanty for your reply,

you second condition work

I used below expression

if(expression>0,expression)

[kashaboinaraj]

Give condition like expression>0

[Anonymous]

Thanks!

---

---

If(Sum(whatever) > 0, Sum(Whatever))

did it for me...

[srini]

Hi Chanty,

I have come across the similar issue. When I try apply your solution it is not working.

When I am applying two methods to avoid zeros both are not working.

my Expression which I have used is =

Rangesum(above(Count({$<DueMonthName = {">$(=Date(Today(), 'MM/DD/YYYY'))"}>}[Issue id]) + IF(DueMonthName = MonthName(Today()),Column(1), 0),0,RowNo()) )

I have tried with below in the Data handling 

if(Rangesum(above(Count({$<DueMonthName = {">$(=Date(Today(), 'MM/DD/YYYY'))"}>}[Issue id]) + IF(DueMonthName = MonthName(Today()),Column(1), 0),0,RowNo()) )>0,Rangesum(above(Count({$<DueMonthName = {">$(=Date(Today(), 'MM/DD/YYYY'))"}>}[Issue id]) + IF(DueMonthName = MonthName(Today()),Column(1), 0),0,RowNo()) ))

Can you please advise?

[Qlik-Developer]

I have five measures and I want to hide zero values for two measures only. How to do that?

[Chanty4u]

Hi,

Can you try this way

If(<Reported Expression> =0, 0, <Budget Expression>)

And in the chart properties, "Add-ons", "Data handling" - uncheck "Show zero values"

and some other possibilities here 

https://community.qlik.com/t5/New-to-Qlik-Sense/Hide-dimension-where-measure-is-null-or-0/td-p/12131...

[Chanty4u]

cool 🙂 

[Lazar1]

I am facing the same issue and none of those suggestions doesn't work...
I have multiple master measures and Week as a dimension.