Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I need your help with the String search.
a text string separated by spaces contains features of my products and I would like to know how I can do a search including "or" and "and"., i.e.:
Product 1: AA BB CC DD EE FF GG
My search: which Products have the features AA and (BB or DD)?
I would like to use "and" / "or" when I search in the text string...
please help me....
Thank you!!
Hi,
You can use the Qlik Sense Search bar for this. This will find all space separated requests.
Jordy
Climber
Try this:
=IF(Match(Product,AA) AND (Match(Product,BB) OR Match(Product,DD)), Product)
Hi Edvin!! thank you very much for your answer!!
do you know how could do that using the filter (search in listbox)?
i.e., when I use "-" then excludes results from my search
then if I search AA and CC or BB, what should insert in the listbox? +AA +BB??
Thank you
Hi,
You can use the Qlik Sense Search bar for this. This will find all space separated requests.
Jordy
Climber