Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Creator
Creator

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
Highlighted
Specialist III
Specialist III

Did you try like this?

(search1|search2|search3)
Highlighted
Specialist III
Specialist III

Highlighted
Creator
Creator

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

Specialist II
Specialist II

When the field is a string, use

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

 

When the field is a number, use

='(value1|value2)'

 

Highlighted
Digital Support
Digital Support

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.