Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to use not like or exclude data?

I'm more  familiar with Access and some SQL, but I need to exclude data in a field and having trouble finding the proper syntax.

The data in this field has several sales people, and I want to exclude those that have inactive anywhere in their name.

#1 I'm not sure how to make the not like statement

#2 What represents a wildcard.

3 Replies
giakoum
Partner - Master II
Partner - Master II

where slspsn_no not like '%inactive%'

Not applicable
Author

perfect, thanks

giakoum
Partner - Master II
Partner - Master II

please Jeremy close the discussion