topic Re: How to use not like or exclude data? in QlikView https://community.qlik.com/t5/QlikView/How-to-use-not-like-or-exclude-data/m-p/831093#M994328 <HTML><HEAD></HEAD><BODY><P>please Jeremy close the discussion</P></BODY></HTML> Fri, 26 Jun 2015 14:09:36 GMT giakoum 2015-06-26T14:09:36Z How to use not like or exclude data? https://community.qlik.com/t5/QlikView/How-to-use-not-like-or-exclude-data/m-p/831090#M994325 <HTML><HEAD></HEAD><BODY><P>I'm more&nbsp; familiar with Access and some SQL, but I need to exclude data in a field and having trouble finding the proper syntax.</P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/90980_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P>The data in this field has several sales people, and I want to exclude those that have inactive anywhere in their name.</P><P>#1 I'm not sure how to make the not like statement</P><P>#2 What represents a wildcard.</P></BODY></HTML> Fri, 26 Jun 2015 13:57:39 GMT https://community.qlik.com/t5/QlikView/How-to-use-not-like-or-exclude-data/m-p/831090#M994325 2015-06-26T13:57:39Z Re: How to use not like or exclude data? https://community.qlik.com/t5/QlikView/How-to-use-not-like-or-exclude-data/m-p/831091#M994326 <HTML><HEAD></HEAD><BODY><P>where slspsn_no not like '%inactive%'</P></BODY></HTML> Fri, 26 Jun 2015 14:00:28 GMT https://community.qlik.com/t5/QlikView/How-to-use-not-like-or-exclude-data/m-p/831091#M994326 giakoum 2015-06-26T14:00:28Z Re: How to use not like or exclude data? https://community.qlik.com/t5/QlikView/How-to-use-not-like-or-exclude-data/m-p/831092#M994327 <HTML><HEAD></HEAD><BODY><P>perfect, thanks</P></BODY></HTML> Fri, 26 Jun 2015 14:04:38 GMT https://community.qlik.com/t5/QlikView/How-to-use-not-like-or-exclude-data/m-p/831092#M994327 2015-06-26T14:04:38Z Re: How to use not like or exclude data? https://community.qlik.com/t5/QlikView/How-to-use-not-like-or-exclude-data/m-p/831093#M994328 <HTML><HEAD></HEAD><BODY><P>please Jeremy close the discussion</P></BODY></HTML> Fri, 26 Jun 2015 14:09:36 GMT https://community.qlik.com/t5/QlikView/How-to-use-not-like-or-exclude-data/m-p/831093#M994328 giakoum 2015-06-26T14:09:36Z