Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have been conducting a search in a QLIKSense app. I am searching for any fields containing the words 'ACTUATOR' and 'ECAM'. The search term I used is:
+actuator +ecam
On closer inspection, the results exclude 'ECAM' preceded by a character e.g. ',ECAM' or '.ECAM'. In other words, it only returns values with a preceding space.
I tried using wildcards with the about but QLIK doesn't appear to accept this. I would like it to return any cells containing 'ecam' and 'actuator', irrespective of what characters precede or succeed them.
Can anyone help?
thanks!
May be a wildmatch like this
WildMatch(Upper(Field), '*ACTUATOR*ECAM*', '*ECAM*ACTUATOR*')
Hi,
I was referring to searches within an app, not script or chart functions.
Is there a solution to this?
Hi James,
If you mean using Smart Search: "smart search only supports text search. Search operators other than quotation marks are not supported." (from here: https://help.qlik.com/en-US/sense/April2018/Subsystems/Hub/Content/Search/use-smart-search-tool.htm)
So you would need to use scripting to create an object/field with the parameters you are looking for (with something like Sunny suggested).
If you are an Administrator and looking for ways to control what is and is not included in Smart Search, you can check out the information here: https://help.qlik.com/en-US/sense/April2018/Subsystems/Hub/Content/Scripting/ScriptRegularStatements...
Hope this helps!
Carmen
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.