Selecting Null Values in set analysis

jedgson — Sun, 25 Apr 2010 20:26:36 GMT

V8.5

I have been scrawling through a lot of posts trying to find a solution to select Null Values in set analysis. Unfortunately all the answers I found did not seem to work.

Finally I managed to solve the issue myself, so I am just posting this to help any who is stuck in the same position.

I was using set analysis with several modifiers - one being a date field (Mod3) of which I needed to select null values.

I found that using Mod3 = would select all values including Nulls and Mod3 = {'*'} would select all non-null values, but I could not find a way to directly select Null values.

The solution I came up with is:

[Code]

Count ({<Mod1 = {'abc'}, Mod2 = {123},Mod3 = > - <Mod3 = {'*'}>} Distinct Field1)

I also tried the following and many more with no success:

Count ({<Mod1 = {'abc'}, Mod2 = {123},Mod3 -= {'*'}>} Distinct Field1)

Count ({<Mod1 = {'abc'}, Mod2 = {123},Mod3 = {$(=Null())}>} Distinct Field1)

If anyone else has another way to do this that is tidier, please let me know?

Jay

Selecting Null Values in set analysis

Miguel_Angel_Baeyens — Mon, 26 Apr 2010 08:07:34 GMT

Hello Jay,

I haven't tested it but it may do

Count({< Mod3 = {"=Len(Mod3) = 0"} >} Distinct Field)

Regards.

Selecting Null Values in set analysis

Tue, 26 Oct 2010 19:49:20 GMT

Yep, this solution worked for me, too. Thanks a bunch!

Count ({<Mod1 = {'abc'}, Mod2 = {123},Mod3 = > - <Mod3 = {'*'}>} Distinct Field1)

topic Selecting Null Values in set analysis in QlikView

Selecting Null Values in set analysis

Selecting Null Values in set analysis

Selecting Null Values in set analysis