Copy/pasting a list of values to search/select in a field
New to the boards here and have a rather specific question. I have some users who would like to be able to copy/paste a list of values from an Excel/etc into Qlik and use them to make selections in a field - i.e. by account number, client ID, etc.
I feel like I've gotten much of the way there but some of the pieces are eluding me. Here's what I've done so far:
1. Created a variable vSearchInput and added a Qlik variable input object in order to receive the copy/pasted values. When pasted in direct from Excel the line breaks are removed and each values gets fed into the variable with a space in between, i.e. "Value1 Value2 Value3 Value4." I wish the line breaks would stay so I could use them as a delimiter instead of the space, but that doesn't seem to be a possibility.
2. Created a variable vSearchString with code "=Trim(Replace('$(vSearchInput)',' ',' | '))" - this replaces the spaces with "|" to turn the input list into a Qlik search string - like 'Value1 | Value2 | Value3 | Value4'.
3. Added a Qlik button with the action "Select values matching search string." This is where I'm failing - no matter how I try to add the vSearchString variable as the Value, it doesn't actually select the values. If I enter '$(vSearchString)' as the value this will work as long as I enter only one search value into the copy/paste box. But nothing I've tried works once I enter a second value.
In summary: Anyone have any thoughts on the proper syntax to use with this kind of "|" search string, stored in a variable, then used to drive the search action on a Qlik button? Thanks in advance for taking a look!