Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
there is an option on the chart Include null values, check if this option is checked, if is, remove from all dimensions
Thanks TcnCunha_M for your reply
there is an option on the chart Include null values, check if this option is checked, if is, remove from all dimensions
Thanks TcnCunha_M for your reply