Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Well, I kept trying different options and ultimately this is what worked:
(*SNOW* OR *ServiceNow* OR "*Service Now*")
... problem solved.
Well, I kept trying different options and ultimately this is what worked:
(*SNOW* OR *ServiceNow* OR "*Service Now*")
... problem solved.