Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try any one of them
Count({<Field = {"=Len(Field)=0"}>} Field)
Count({<Field = {"=Null()"}>} Field)
Count(If(Len(Field)=0, Field))
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 ?