Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
wdchristensen
Specialist
Specialist

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)

1 Solution

Accepted Solutions
sunny_talwar

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

View solution in original post

2 Replies
sunny_talwar

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
Specialist
Specialist
Author

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)