# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor III

## Not null condition in set analysis

Hi All,

I have a measure in which the set analysis condition is not null. The measure is Count([Case ID]) where Case Create Date is not null.

So will the formula of this measure be Count({<[Case Create Date]-={*}>}[Case ID])?

Can anyone please let me know the proper syntax of writing this set analysis.

Thanks.

7 Replies
Honored Contributor III

## Re: Not null condition in set analysis

try this

Count( {\$<[Case Create Date]={"=Len(Trim([Case Create Date]))>0"}>}[Case ID])

or

Count( {\$<[Case Create Date]={">0"}>}[Case ID])

MVP

## Re: Not null condition in set analysis

Nulls will not be included in the Count. No set expressions required.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Esteemed Contributor III

## Re: Not null condition in set analysis

try

=Count(if(isnull([Case Create Date]),[Case ID]),[Case ID])

New Contributor II

## Re: Not null condition in set analysis

Try this

Count({<[Case Create Date]-={"","NULL"}>}[Case ID]

Regards

Honored Contributor III

## Re: Not null condition in set analysis

Count(If(Len([Case Create Date])>0,[Case ID])

or

Count({\$<[Case ID]={'=Len(Trim([Case Create Date]))>0'}>}[Case ID])

MVP

## Re: Not null condition in set analysis

Count({<[Case Create Date]={"*"}>}[Case ID])

MVP

## Re: Not null condition in set analysis

jontydkpi‌ I think the OP wants to count Case ID where Case Create Date is not null. I think in this case, since Case ID is not null, it might still get counted. I think what rbecher‌ has provided should work perfectly if Case Create Date is true null.