Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
rajarshi_guin
Contributor III
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
Master III
Master III

try this

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

or

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

jonathandienst
Partner - Champion III
Partner - Champion III

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

try

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

seydiozer
Contributor II
Contributor II

Try this

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


Regards

sasiparupudi1
Master III
Master III

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

or

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

rbecher
MVP
MVP

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

Astrato.io Head of R&D
sunny_talwar

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.