topic Where clause in QlikView https://community.qlik.com/t5/QlikView/Where-clause/m-p/483761#M180753 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a sql view linked to my dashboard with session speciality, I also have a spreadsheet linked in by speciality. I only want the dashboard to show information regarding the specialties that appear on the spreadsheet. I have managed to get the list box only looking at the excel spec but some other fields in the dashboard are still taking into account the other specs. How do I exclude the certain specs from the whole dashboard?</P><P></P><P>Do I do a where clause saying :</P><P></P><P>where speciality not in ('1','2','3' ... etc) Will that filter out any information to do with those specs?</P><P></P><P>Thanks,</P></BODY></HTML> Thu, 26 Sep 2013 15:25:12 GMT 2013-09-26T15:25:12Z Where clause https://community.qlik.com/t5/QlikView/Where-clause/m-p/483761#M180753 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a sql view linked to my dashboard with session speciality, I also have a spreadsheet linked in by speciality. I only want the dashboard to show information regarding the specialties that appear on the spreadsheet. I have managed to get the list box only looking at the excel spec but some other fields in the dashboard are still taking into account the other specs. How do I exclude the certain specs from the whole dashboard?</P><P></P><P>Do I do a where clause saying :</P><P></P><P>where speciality not in ('1','2','3' ... etc) Will that filter out any information to do with those specs?</P><P></P><P>Thanks,</P></BODY></HTML> Thu, 26 Sep 2013 15:25:12 GMT https://community.qlik.com/t5/QlikView/Where-clause/m-p/483761#M180753 2013-09-26T15:25:12Z