Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to check for Null values in set expression

Hi,

I have to count ext_id for those having Segment as null.

So in expression I wrote count({< Isnull(Segment)>} ext_id)

but it's not working.

Regards,

Tanay

11 Replies
sunny_talwar

May be this

Count({<ext_id = {"=Len(Trim(Segment)) = 0"}>}ext_id)

vishsaggi
Champion III
Champion III

Can you write this Sunny?

= Count({<ext_id -= {" * "} >} ext_id)

sunny_talwar

We are not checking for a null condition on ext_id.... why use this? ext_id -= {" * "}

vishsaggi
Champion III
Champion III

OOps ignore. I got that. Sorry.

May be this: ?

= Count({< Segment -= {" * "} >} ext_id)

sunny_talwar

But the requirement is to count ext_id where Segment is null

oscar_ortiz
Partner - Specialist
Partner - Specialist

Have you tried the NullCount(ext_id) function?

Good luck

Oscar

oscar_ortiz
Partner - Specialist
Partner - Specialist

NullCount(Segment)

vishsaggi
Champion III
Champion III

You are right it should be segment.

arjakumar
Contributor III
Contributor III

This one may works

Count({<Segment = {'Isnull(Segment)'}>}ext_id)