To clarify, when I say "not working" I mean the rows aren't being hidden (which is actually working correctly; I wouldn't expect an IF statement to cause rows to be hidden). The 'test' column here is basically the same:
You learn something new every day (on this forum)!
I foresee having to add a few more conditions, with nesting, to this IF statement, so I'm worried about performance. Theoretically set analysis may be better, so I'm interested in making it work (if only for the sake of learning).
Any thoughts as to why my above syntax might not work?
Hmmmmm.... I'll have to think about that. The two tables have only the Patient in common, and each has ~10 million rows, so joining would create a table with many tens or hundreds of millions of rows. I know Qlik does some interesting stuff with storage, so maybe it's not so undesirable.
But the bottom line is the two fields must be in the same table to do a comparison in set analysis?