Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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