Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ahmar811
Creator III
Creator III

Hide Zero value line chart

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.

Capture.PNG

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

Regards

Ahmar

1 Solution

Accepted Solutions
Chanty4u
MVP
MVP

goto data handling tab

un tick suppress null value.   or

conditional :

your expression>0

View solution in original post

9 Replies
Chanty4u
MVP
MVP

goto data handling tab

un tick suppress null value.   or

conditional :

your expression>0

ahmar811
Creator III
Creator III
Author

Thanks, Chanty for your reply,

you second condition work

I used below expression

if(expression>0,expression)

kashaboinaraj
Creator
Creator

Give condition like expression>0

Anonymous
Not applicable

Thanks!



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

did it for me...

srini
Creator
Creator

Hi Chanty,

 

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

 

line Chart with zeros.JPG

 

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

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

Chanty4u
MVP
MVP

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
MVP
MVP

cool 🙂 

Lazar1
Contributor III
Contributor III

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

Lazar1_0-1691659954925.png