Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
eliegogotpe
Contributor
Contributor

Nullable Values

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

3 Replies
Anil_Babu_Samineni

Try any one of them

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

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

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
eliegogotpe
Contributor
Contributor
Author

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 ?