topic Re: How to Exclude one department in QlikView https://community.qlik.com/t5/QlikView/How-to-Exclude-one-department/m-p/655398#M1081156 <HTML><HEAD></HEAD><BODY><P>That´s great!</P><P>Please mark this question as answered.</P></BODY></HTML> Wed, 25 Jun 2014 16:35:49 GMT Clever_Anjos 2014-06-25T16:35:49Z How to Exclude one department https://community.qlik.com/t5/QlikView/How-to-Exclude-one-department/m-p/655393#M1081151 <HTML><HEAD></HEAD><BODY><P>Can someone please help me with excluding one department. </P><P></P><P>For example AdmissionDept I want to exclude 6 NorthEast</P><P></P><P>How will I write a script?</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 25 Jun 2014 16:04:13 GMT https://community.qlik.com/t5/QlikView/How-to-Exclude-one-department/m-p/655393#M1081151 2014-06-25T16:04:13Z Re: How to Exclude one department https://community.qlik.com/t5/QlikView/How-to-Exclude-one-department/m-p/655394#M1081152 <HTML><HEAD></HEAD><BODY><P><BR />if(AdmissionDept &lt;&gt;'NorthEast' ,AdmissionDept)</P></BODY></HTML> Wed, 25 Jun 2014 16:09:08 GMT https://community.qlik.com/t5/QlikView/How-to-Exclude-one-department/m-p/655394#M1081152 santharubban 2014-06-25T16:09:08Z Re: How to Exclude one department https://community.qlik.com/t5/QlikView/How-to-Exclude-one-department/m-p/655395#M1081153 <HTML><HEAD></HEAD><BODY><P>LOAD</P><P>*</P><P>from yourqvd(qvd)</P><P>where AdmissionDept &lt;&gt;'NorthEast';</P></BODY></HTML> Wed, 25 Jun 2014 16:10:53 GMT https://community.qlik.com/t5/QlikView/How-to-Exclude-one-department/m-p/655395#M1081153 Clever_Anjos 2014-06-25T16:10:53Z Re: How to Exclude one department https://community.qlik.com/t5/QlikView/How-to-Exclude-one-department/m-p/655396#M1081154 <HTML><HEAD></HEAD><BODY><P>another one</P><P></P><P>load </P><P>&nbsp;&nbsp;&nbsp;&nbsp; *</P><P>from</P><P>&nbsp;&nbsp;&nbsp;&nbsp; ......</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12.727272033691406px;">where not match(AdmissionDept, 'NorthEast');</SPAN></P></BODY></HTML> Wed, 25 Jun 2014 16:27:58 GMT https://community.qlik.com/t5/QlikView/How-to-Exclude-one-department/m-p/655396#M1081154 maxgro 2014-06-25T16:27:58Z Re: How to Exclude one department https://community.qlik.com/t5/QlikView/How-to-Exclude-one-department/m-p/655397#M1081155 <HTML><HEAD></HEAD><BODY><P>Thank you very much! That worked <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 25 Jun 2014 16:33:11 GMT https://community.qlik.com/t5/QlikView/How-to-Exclude-one-department/m-p/655397#M1081155 2014-06-25T16:33:11Z Re: How to Exclude one department https://community.qlik.com/t5/QlikView/How-to-Exclude-one-department/m-p/655398#M1081156 <HTML><HEAD></HEAD><BODY><P>That´s great!</P><P>Please mark this question as answered.</P></BODY></HTML> Wed, 25 Jun 2014 16:35:49 GMT https://community.qlik.com/t5/QlikView/How-to-Exclude-one-department/m-p/655398#M1081156 Clever_Anjos 2014-06-25T16:35:49Z