topic Re: How to add Multiple Searches to a Search String in a Text Object in QlikView

How to add Multiple Searches to a Search String in a Text Object

oliveton — Sat, 16 Nov 2024 18:22:07 GMT

I have a text object where I want to add multiple searches in a search string, but it's not working.

I've read on a different post where you can divide the different searches like so "search1|search 2|search 3" but that is not working.

Is there another way to do this ?

Thanks sooo much !!!

Re: How to add Multiple Searches to a Search String in a Text Object

Saravanan_Desingh — Tue, 14 Jul 2020 20:49:21 GMT

Did you try like this?

(search1|search2|search3)

Re: How to add Multiple Searches to a Search String in a Text Object

Saravanan_Desingh — Tue, 14 Jul 2020 20:52:20 GMT

Check this link.

https://community.qlik.com/t5/QlikView-Documents/Compound-Search-demystified/ta-p/1494410

Re: How to add Multiple Searches to a Search String in a Text Object

oliveton — Tue, 14 Jul 2020 20:57:07 GMT

I did try it like that also and it didn't work, not sure what is going on. What I ended up doing is instead of choosing "select in field" is to choose "select possible" which selected everything possible in that field and this worked.

Thanks for your help!

Re: How to add Multiple Searches to a Search String in a Text Object

jwjackso — Tue, 14 Jul 2020 20:59:38 GMT

When the field is a string, use

='("value1"|"value2")'

When the field is a number, use

='(value1|value2)'

Re: How to add Multiple Searches to a Search String in a Text Object

Brett_Bleess — Thu, 23 Jul 2020 16:42:20 GMT

I believe the issue in this case was the need to use the Toggle Select action instead of the Select in Field:

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Button2.htm#anchor-4

Glad the other option worked for you.

Regards,
Brett