How to remove nulls from a measure

[sersal10]

Hi all, 
I want to remove nulls so that I can calculate the percentaje of the countries but not taking into account the NULLs in the calculation. This code doesn't work. The measure is the same as with the nulls.

Any solution for this?

Many thanks

[vincent_ardiet_]

Try with this filter in your set analysis:
customer_country={*}

[sersal10]

Hi Vincent,

I tried this in the expression: Sum({<customer_country = {*} quantity) / Sum({<customer_country = {*} >} total quantity) and it says there is an error. It doesn't show anything then.

[vincent_ardiet_ · Accepted solution]

Maybe a small typo here:

Sum({<customer_country = {*}>} quantity) / Sum({<customer_country = {*} >} total quantity)

[sersal10]

Thank you so much!! It worked 🙂

[maheshkuttappa]

Sum({<Customer_Country ={"*"}>} Quantity)  

This will pick up all possible values in Customer_Country and ignore the null. If data has text values like null, n/a then this expression will include it.  It is better to handle the null value in the script. 

This an excellent resource NULL handling in QlikView