
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Set Analysis for blank/null or a Value on the same field in data
Hi,
Is there a way to return rows in the data that have blank or null or some value in the same column using set analysis?
I am trying to get sum of dollars for Order Year =2019 or Order Year is null or order year is blank
Here is my expression.
SUM({<[ORDER_DATE] -={'*'},[ORDER_DATE] = {'2019*'}>} DOLLARS)
ORDER_DATE is a Date Key field in the data. I cannot make changes to the load script it has to be in the Set expression.
Can someone please help?
Thanks


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Maybe:
SUM({<[ORDER_DATE] -={'*'}> + <[ORDER_DATE] = {'2019*'}>} DOLLARS)
.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Have a look at the following Design Blog post, it may be of some help if the other post did not work, but if that post did work, be sure to circle back to the thread and use the Accept as Solution button on the post to give the poster credit for the assistance and let other Community Members know it worked.
https://community.qlik.com/t5/Qlik-Design-Blog/Excluding-values-in-Set-Analysis/ba-p/1471704
Here is another main one that has some other links in it:
https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344
Regards,
Brett
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
