
Not applicable
2015-06-26
09:57 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Tags:
- new_to_qlikview
852 Views
3 Replies


Partner - Master II
2015-06-26
10:00 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
where slspsn_no not like '%inactive%'

Not applicable
2015-06-26
10:04 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
perfect, thanks
752 Views


Partner - Master II
2015-06-26
10:09 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
please Jeremy close the discussion
752 Views
