Qliksense Pie Chart: Excluding Null values

[#1]

I have a pie chart showing the percentage of male/female answered our questionnaire, but there are some null values for some purposes, I tried to filter in the calculation field:

if([c-i-hh_gender]= Null() ,null(),count(KEY))

It didn't work for me.

P.S. I'm using Qliksense.

[#2]

Ralf, I don't use Sum, we use count of records in this situation as each record represents one person.

Thanks, -Hanan

[rbecher]

Of course, but if Gender is dimension why you would need a set analysis fiter?

[#4]

Because I have NULL values or records without asking what is the gender of the person and that is done on purpose. So it means nothing to me if it says 10% Null value, I don't need this value, I need to deal with the gender value in a way which is different from the null value sample.

[rbecher]

Sure, but why not upload an example to get helped in the right way?