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

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
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

How about this

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

View solution in original post

2 Replies
sunny_talwar

How about this

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