topic Comparing field value to NULL in set analysis in QlikView

Comparing field value to NULL in set analysis

Thu, 28 Jul 2011 16:11:22 GMT

I need to have a chart where expression should produce a count of field A when field B is NULL and second count when field B is not NULL.

Something like this but with correct syntax.

=count({$<=NULL>}) - this does not work

Is there any other way to implement such logic?

Thank you

Comparing field value to NULL in set analysis

danielrozental — Thu, 28 Jul 2011 17:54:37 GMT

No, there is no way to select null values.

You could try something like this count(if(isnull(B),A))

Comparing field value to NULL in set analysis

Thu, 28 Jul 2011 18:32:40 GMT

What if I replae NULLs with soething else during the load - lets say with string "xyz". can I use

=count({$<="xyz">}) ?

Comparing field value to NULL in set analysis

danielrozental — Thu, 28 Jul 2011 18:44:50 GMT

Yes, but the correct expression would be

=count({$<={'xyz'}>})

Comparing field value to NULL in set analysis

Thu, 28 Jul 2011 18:53:55 GMT

Try...

= Count ({$ < = {$(=null())}>} ) // Null

= Count ({$ < -= {$(=null())}>} ) // Not null

Comparing field value to NULL in set analysis

Thu, 28 Jul 2011 21:14:53 GMT

ehilsinger - it does not work for me, did it work for you?

Comparing field value to NULL in set analysis

erichshiino — Fri, 29 Jul 2011 04:21:35 GMT

Hi,

You can write something like this:

count({1-<={*}>})

Explanation:

count({<={*}>}) -> this will count A where B has any value (can be a blank but not a null)

count({1-<={*}>}) -> the '1-' tells that you want to see everything (1) excluding cases where B has value

Hope this helps,

Erich

Re: Comparing field value to NULL in set analysis

Mon, 09 Jul 2012 22:39:45 GMT

counts A when B is null

=count({$<={"=isnull(B)"}>})

counts A when B is not null

=count({$<={"*"}>})

Re: Comparing field value to NULL in set analysis

raajeshn — Sun, 12 Aug 2012 07:31:25 GMT

Hi Erich,

I also had a similar problem and your solution worked for me. Thanks a lot.

Regards,

Raajesh N

Re: Comparing field value to NULL in set analysis

qliksus — Tue, 14 Aug 2012 02:46:41 GMT

Hi u can try something like

count({$<={"=NULLCOUNT()>0"}>}) +

count({$<={"=NULLCOUNT()=0"}>})