Set Analysis for blank/null or a Value on the same field in data

[abhiM]

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

[m_woolf]

Maybe:

SUM({<[ORDER_DATE] -={'*'}> + <[ORDER_DATE] = {'2019*'}>} DOLLARS)

[Brett_Bleess]

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