topic Re: Nullable Values in App Development

Nullable Values

eliegogotpe — Mon, 20 Dec 2021 21:38:40 GMT

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

Re: Nullable Values

Anil_Babu_Samineni — Mon, 06 Jan 2020 13:57:50 GMT

Try any one of them

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

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

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

Re: Nullable Values

Kushal_Chawda — Mon, 06 Jan 2020 14:58:15 GMT

see the below blog

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

Re: Nullable Values

eliegogotpe — Mon, 06 Jan 2020 15:40:57 GMT

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 ?