Set Analysis - Counting NULL Values

[#1]

I'm trying to count NULL values using Set Analysis. I basically use this code:

Count({$<[EagleFeedback.Win/Loss]={}>} [EagleFeedback.Win/Loss])

It never returns any values even though I know there are some.

How do I use Set Analysis to count NULL values?

[Anonymous]

How about:

SUM(-ISNULL([EagleFeedback.Win/Loss]))

I was having the same problem and this is what I ended up with. Set Analysis is very finicky about null values.

Hope this helps anyone else.

[erjohnso]

If your EagleFeedback.Win/Loss carries only 'Win', 'Loss' or NULL values, try this:

Count({$-1<[EagleFeedback.Win/Loss]={'Win','Loss'}>} [EagleFeedback.Win/Loss])

[antoniotiman]

You can Try :

Count({[EagleFeedback.Win/Loss]-={'*'}>} [EagleFeedback.Win/Loss)      (or -={*})

[lars_plenge]

You can use:

count({$<Customer={"=isnull(Address)"}>} Customer)

[#6]

In this link i found the solution, it worked for me.

How to handle NULL values​​, ANDs and ORs in SET ANALYSIS: | QlikView Help, Tips & Hints

[antoniotiman]

Hi Dave,

what is the origin of your data ?

DB or Load ?

[jaimeaguilar]

Hi,

in my experience I can tell you that probably the only option with set analysis that will work for you is similar to what the blog suggested by Eugenio says:

Count({1 - <[EagleFeedback.Win/Loss]={'*'}>} [EagleFeedback.Win/Loss])

Otherwise, you can use NULLASVALUE in script in order to assign a string/numeric default value for nulls:

NULLASVALUE [EagleFeedback.Win/Loss];

Set NullValue = 'N/A';

regards