Nullable Values

[eliegogotpe]

Hello, 

How to handle Nullable data in qlik ? I explain my self, in my data abse, there is a column that can  contain values as null. In my analysis, i want to count those empty fields . is that possible ? 

Thank you

[Anil_Babu_Samineni]

Try any one of them

Count({<Field = {"=Len(Field)=0"}>} Field)

Count({<Field = {"=Null()"}>} Field)

Count(If(Len(Field)=0, Field))

[Kushal_Chawda]

see the below blog

https://community.qlik.com/t5/QlikView-Documents/NULL-handling-in-QlikView/ta-p/1484472

[eliegogotpe]

Thank you for your reply. 

Should i put it in the Data Load part ? 

My script looks like this:
Load [ID]
Resident [ex] Group By [ID]

And then i add one of the formulas after ?