As an aside, quite frankly I could never get EXISTS and NOT EXISTS to work in Qlikview. I honest wish Qlikview adopted a more SQL-like exists clause.<p>(P.S. I used to do SELECT 1 because it was shorthand... Funny how people thought it was a magic speed up!)