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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
MikeatAO
Contributor
Contributor

Using an Expression in the Search Field of a Text Column in a Table

Using QlikSense, I have a table with several columns of data and one text column for 'Work Scope'.  The table has  millions of rows, and I want to search the 'Work Scope' field for all entries including the tool "ServiceNow".  However, the source data entries are hand entered and could be written as "SNOW" or "ServiceNow" or "Service Now".

I thought I could write a simple expression in the search bar for that field but it doesn't seem to work.  I've tried many variations like this:

=[field name] LIKE '*SNOW*' or [field name] LIKE '*ServiceNow*' or [field name] LIKE '*Service Now*'

But none seems to work.  Can anyone point me to how the syntax of this should be done?

Thanks!

Labels (1)
1 Solution

Accepted Solutions
MikeatAO
Contributor
Contributor
Author

Well, I kept trying different options and ultimately this is what worked:

(*SNOW* OR *ServiceNow* OR "*Service Now*")

... problem solved.  

View solution in original post

1 Reply
MikeatAO
Contributor
Contributor
Author

Well, I kept trying different options and ultimately this is what worked:

(*SNOW* OR *ServiceNow* OR "*Service Now*")

... problem solved.