Set Analysis for Null condition (Qlik Sense)

[wdchristensen]

I have a field called Delay flag and I want to count all occurrences of null values and some other conditions (simplified below into 1=1). The only values in the DelayFlag field are 1 and null. So I thought I could use the not 1 logic but this gives all zeros. Please help me rewrite this statement correctly. Thanks community!

Count({<

1=1

,DelayFlag = -  {'1'}

//,DelayFlag =  Null

>}

Distinct Id)

[sunny_talwar · Accepted solution]

May be try this

Count({<Id = {"=Len(Trim(DelayFlag)) = 0"}>} Distinct Id)

or

Count({<Id = {"=DelayFlag <> 1"}>} Distinct Id)

UPDATE: Added the closing "} which were missing earlier

[wdchristensen]

Thanks Sunny, your solution worked like a charm. Your answer suggestion was exactly what I was looking for, just needed to add closing quote and bracket. I appreciate your help!

Count({<

1=1

,ID = {"=DelayFlag <> 1"}

>}

Distinct Id)