Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Maybe:
SUM({<[ORDER_DATE] -={'*'}> + <[ORDER_DATE] = {'2019*'}>} DOLLARS)
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