
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Selecting Null Values in set analysis
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
.png)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello Jay,
I haven't tested it but it may do
Count({< Mod3 = {"=Len(Mod3) = 0"} >} Distinct Field)
Regards.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Yep, this solution worked for me, too. Thanks a bunch!
Count ({<Mod1 = {'abc'}, Mod2 = {123},Mod3 = > - <Mod3 = {'*'}>} Distinct Field1)
