Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rajarshi_guin
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
arulsettu
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
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
Chanty4u
Esteemed Contributor III

Re: Not null condition in set analysis

try

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

seydiozer
New Contributor II

Re: Not null condition in set analysis

Try this

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


Regards

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

Re: Not null condition in set analysis

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

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.

Community Browser