Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
oliveton
Creator
Creator

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

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 !!! 

oliveton_0-1594758428329.png

 

Labels (3)
1 Solution

Accepted Solutions
oliveton
Creator
Creator
Author

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! 

View solution in original post

5 Replies
Saravanan_Desingh

Did you try like this?

(search1|search2|search3)
oliveton
Creator
Creator
Author

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! 

jwjackso
Specialist III
Specialist III

When the field is a string, use

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

 

When the field is a number, use

='(value1|value2)'

 

Brett_Bleess
Former Employee
Former Employee

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#anc...

Glad the other option worked for you.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.