Please note : unchecking this "Show null values" option - will suppress null values only - if these values are represented as 0, this option will not work, can you please verify if this works for you. It does not work for me using your sample data.
What does work is this:
Is select the dimension customers - and select the Limitation option and choose > 0
I attached a sample for you. Copy to C:\Users\<user profile>\Documents\Qlik\Sense\Apps and press F5 in the hub to see the app.
Let us know how you do
Please mark the appropriate replies as helpful / correct so our team and other members know that your question(s) has been answered to your satisfaction.
A sum() on missing values will usually produce a 0 (see pf 10-11 of null or nothing whitepaper), but if there are true NULL values that have been calculated as such in Qlik or loaded from a database , then things can change.
Thanks for your suggestions Jonathan. I tried inputting this in a few ways with similar results. You can check the qvf and xls. The data source we are actually using is Oracle. The values are loading as nulls. Unless I am still missing something it looks like sum of a null value is showing as zero.