Bar Chart don't show 0% values

[MikeJones]

Hi, I am using the measure below to generate a bar chart in Qlik Sense to show the bottom 10.  The chart is currently showing certain employees who have 0%.  How can I not show those employees with 0% using the expression?

I don't have the ability to share the data I am using.

sum({<[QLIK_OnDayPerformance.Employer]={'XXXX'},client={'XXXX'},
Date={">=$(=WeekStart(Today()-28))<=$(Date<WeekStart(Today())))"},[OutcomeResource-ResourceName]-={'XXXX'}>}CommissionedCount)/

sum({<[QLIK_OnDayPerformance.Employer]={'XXXX'},[QLIK_OnDayPerformance.SmartTrad]={'XXXX'},OnDayOutcome-={'XXXX', 'YYYY'},client={'XXXX'},
MetersInstalled-={'0'},Date={">=$(=WeekStart(Today()-28))<=$(Date<WeekStart(Today())))"},[OutcomeResource-ResourceName]-={'XXXX'}>}CommissionDenominator)

[TcnCunha_M · Accepted solution]

there is an option on the chart  Include null values, check if this option is checked, if is, remove from all dimensions

[MikeJones · Accepted solution]

Thanks TcnCunha_M for your reply