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: 
Not applicable

Set Analysis Is Not Null and another column is Null

Hi,

I'm trying to write a set analysis where I'm counting where column A is not null and where column B is null.

I can only get the one part write.

I have tried the following:

=sum({($ -<B={'*'}>) * <A={'0'}>} ID)

=if(isnull(A),count(DISTINCT{$<B={'*'}>}ID))

Thank you

1 Reply
tresesco
MVP
MVP

Try like:

=sum({($ -<B={'*'}>) * <A={'*'}>} ID)