topic Re: Set Analysis for Null condition (Qlik Sense) in App Development

Set Analysis for Null condition (Qlik Sense)

wdchristensen — Wed, 10 May 2017 19:29:02 GMT

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)

Re: Set Analysis for Null condition (Qlik Sense)

sunny_talwar — Wed, 10 May 2017 19:32:06 GMT

May be try this

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

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

UPDATE: Added the closing "} which were missing earlier

Re: Set Analysis for Null condition (Qlik Sense)

wdchristensen — Wed, 10 May 2017 20:16:49 GMT

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)