1 Reply Latest reply: Apr 5, 2018 7:30 AM by Sunny Talwar RSS

    Search two strings with wildcards

    James Cose

      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!