just by looking at your query we understand the problem but your description does not provide any information on HOW EXACTLY you are applying the filters in Sql server or Qlikview!
You haven't posted your sql query neither your qlikview load statement; and people can't really help you find a problem they can't see!
You can use your SQL select statement in conjunction with the load statement as below, so no need to recreate your sql query in qlikview
SQL SELECT field1,field2,field3
FROM <<>> WHERE <<>>;