You don't say what brand of database you are using, I mostly use Oracle databases.
I would at the Oracle level see what SQL is actually being generated by Direct Discovery and start from there, as it could reveal a join or where clause you are not expecting.
It would be nice if one could see the SQL from the QlikView level, but I don't believe that is possible.
