Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
srini
Creator
Creator

Removing zeros in line chart

Hi Friends,

 

I am looking for a help to remove zero values from line chart.

zero to be removed.JPG

 

I have tried the below option it is not working.

include zero.JPG

 

My expression is: 

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

 

Can some one pls tell me is there any solution for this?

3 Replies
Claudiu_Anghelescu
Specialist
Specialist

Check if Include Zero Values is unchecked also in the Measure
To help community find solutions, please don't forget to mark as correct.
srini
Creator
Creator
Author

I don't see any such options for measure in qlik Sense. I hope it is common option in add-ons.

 

Claudiu_Anghelescu
Specialist
Specialist

In the right pane

To help community find solutions, please don't forget to mark as correct.