Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
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))

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 ?