Hello,
This idea makes reference to this issue
https://community.qlik.com/t5/Qlik-Sense-App-Development/NULL-FIELD-PROBLEM-IN-SET-ANALYSIS/td-p/138...
So, let's say you have this table
and you must sum the measure when the field Dimension_2 is not null. You will write :
Sum({$<Dimension_2= {"*"}>} Measure}
And it works fine
![image.png image.png](https://community.qlik.com/t5/image/serverpage/image-id/24094i3D2BF531ABCBAB06/image-size/large?v=v2&px=999)
Buuuuuuuuuuuuuuuuuuut let's have this table without the last row
not a big deal, you may think...
![image.png image.png](https://community.qlik.com/t5/image/serverpage/image-id/24097i6EF30AD803942FE1/image-size/large?v=v2&px=999)
Surprise !!
The set analysis {$<Dimension_2= {"*"}>} is not even taken into account !
Frankly, and given the fact that this behaviour is not documented , I would consider that a bug and a big one.
Please, Qlik, can you have this working as expected?
Best regards,
Simon
Bi Consultant (Dataviz & Dataprep) @ Business & Decision