Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
im
Partner - Contributor II
Partner - Contributor II

Set Analysis - Exclude some values but keep nulls

Hi

I've been searching everywhere but all solutions for exclude in set analysis also take out null values, which I don't want.

=Count(distinct {$< OverallOutcome-={'Set Up in Error'}>} ReferenceNumber)  excludes all nulls

I  tried - 

=Count(distinct  ReferenceNumber) -Count(distinct {$< OverallOutcome={'Set Up in Error'}>} ReferenceNumber) 

but that does row by row calculations in effect assigning negative values to errors and removing them twice.

Help!

1 Solution

Accepted Solutions
sunny_talwar
MVP
MVP

How about this

=Count(DISTINCT {$<ReferenceNumber = e({<OverallOutcome ={'Set Up in Error'}>})>} ReferenceNumber)

View solution in original post

2 Replies
Shubham_Deshmukh
Specialist
Specialist

sunny_talwar
MVP
MVP

How about this

=Count(DISTINCT {$<ReferenceNumber = e({<OverallOutcome ={'Set Up in Error'}>})>} ReferenceNumber)