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: 
Not applicable

Select In Field more than one result

I want to create a button that will enable me to select more than one search string.  For example, I want to select Both November and December when i click the button.  Right now it is either one, it does not choose both for me.  Help

1 Solution

Accepted Solutions
MayilVahanan

HI

Try like this

='(*'&'November'&'*|*'&'December'&'*)'

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

3 Replies
Anonymous
Not applicable
Author

You can use advanced search. Here's an example from the F1 help in QlikView:

=MyField like 'A* or MyField like '*Z' if e.g. invoked from a list box containing the field MyField, the search would return all field values either starting with the letter A or ending with the letter Z.
MayilVahanan

HI

Try like this

='(*'&'November'&'*|*'&'December'&'*)'

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Vegar
MVP
MVP

Hi,

Try

='(November|December)'

OR

='(November OR December)'

Best regards

Vegar Lie Arntsen

QlikView consultant at egbs consulting ab

Blog (in Swedish): bi-effekten.se