Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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