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

MikeatAO — Fri, 28 Feb 2025 01:41:58 GMT

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!

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

MikeatAO — Fri, 28 Feb 2025 02:18:24 GMT

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

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

... problem solved.

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

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

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