topic Re: How to check for Null values in set expression in QlikView

How to check for Null values in set expression

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: How to check for Null values in set expression

sunny_talwar — Tue, 03 Oct 2017 15:44:10 GMT

May be this

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

Re: How to check for Null values in set expression

vishsaggi — Tue, 03 Oct 2017 15:45:17 GMT

Can you write this Sunny?

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

Re: How to check for Null values in set expression

sunny_talwar — Tue, 03 Oct 2017 15:46:25 GMT

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

Re: How to check for Null values in set expression

vishsaggi — Tue, 03 Oct 2017 15:49:29 GMT

OOps ignore. I got that. Sorry.

May be this: ?

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

Re: How to check for Null values in set expression

sunny_talwar — Tue, 03 Oct 2017 15:50:30 GMT

But the requirement is to count ext_id where Segment is null

Re: How to check for Null values in set expression

oscar_ortiz — Tue, 03 Oct 2017 15:50:58 GMT

Have you tried the NullCount(ext_id) function?

Good luck

Oscar

Re: How to check for Null values in set expression

oscar_ortiz — Tue, 03 Oct 2017 15:51:57 GMT

NullCount(Segment)

Re: How to check for Null values in set expression

vishsaggi — Tue, 03 Oct 2017 15:53:14 GMT

You are right it should be segment.

Re: How to check for Null values in set expression

arjakumar — Tue, 03 Oct 2017 15:54:56 GMT

This one may works

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

Re: How to check for Null values in set expression

sunny_talwar — Tue, 03 Oct 2017 15:55:32 GMT

I don't think this will work because Null Segments cannot be selected using this logic because the Segment is null

Segment -= {" * "}

Re: How to check for Null values in set expression

vishsaggi — Tue, 03 Oct 2017 16:03:19 GMT

Oh ok. Got it. Thanks for clarification.