I can't reproduce your isse.
But I've needed to make some assumptions, because you haven't explained your data model, and set analysis is pretty much sensitive to your model (like most of QV).
I assumed you are using a data island for your current / previous BD records.
Check attached. If this does not match your setting, please adapt and repost.
comm89525.qvw 137.0 K
Thanks for helping out with this. The expression that I posted was simplified to try to isolate the problem. This seems to confirm that the problem is not what I thought it was. There are in fact 13 fields that are used to filter the data in this same way. If I were to add Business Unit to the mix the expression would look like this:
I think I will actually mark this as answered. The answer is no, QlikView doesn't handle this situation as I expected.
Well, not sure about that.
You do a distinct count of MATTER_ID, so even if a 'condition' is met twice for that ID, it will only count once (distinct).
I personally don't see a set expression's field modifier like
BUSINESS_DIVISION_D = BUSINESS_DIVISION
as a condition or comparison, rather than an assignment (where only matching values can be assigned).
I am not sure what causes your issue. If you need help, you need to provide more info about your data model and expressions, best by posting a small sample app that demonstrates your issue. Often, while building the sample app, you get to know what causes your issue by yourself...