Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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