While debugging another problem, I ran into something that I was unfamiliar with. Apparently, if I have a SUM measure, with a condition set to a value that doesn't exist, Qlik will ignore it and sum over the entire field. For instance.
Null() AS 'payType'
LOAD * Inline
Now as we see, the 'payType' field is null. But when I have this set analysis in the UI, I am left astonished.
Does anyone know why it's summing over everything? when Null() != 'Foo' ?