Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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.