Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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
MVP
MVP

Re: Set Analysis Is Not Null and another column is Null

Try like:

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