Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
nzcncfan
Contributor II
Contributor II

How to search text in a table field?

I could search from a table field any records containing "sale" using "sale*". However, is there a way that I could search any records DO NOT contain "sale" in the table?

Thanks

1 Solution

Accepted Solutions
swuehl
MVP
MVP

If a normal search retrieves all values to exclude, then you can use a minus to exclude these

-sale

If the search to find all values you want to exclude contains a wildcard, you can get all excluded values using a compound search like

(* ^ "sale*")

View solution in original post

3 Replies
vmoreno2605
Creator
Creator

Capture.PNG

Searh the word 'sale', select it and then there is an option that says 'Select alternative' this will automatically select every possible option that does not have the word sale

swuehl
MVP
MVP

If a normal search retrieves all values to exclude, then you can use a minus to exclude these

-sale

If the search to find all values you want to exclude contains a wildcard, you can get all excluded values using a compound search like

(* ^ "sale*")

nzcncfan
Contributor II
Contributor II
Author

Thanks for your help!