Qlik Community

Qlik Sense App Development

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

wdchristensen
Contributor III

Set Analysis for Null condition (Qlik Sense)

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)

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: Set Analysis for Null condition (Qlik Sense)

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

2 Replies
MVP
MVP

Re: Set Analysis for Null condition (Qlik Sense)

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
Contributor III

Re: Set Analysis for Null condition (Qlik Sense)

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)