Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
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)