Users have a spreadsheet with a column of values. I'd like to make it easy for them to use those values as a selection in my QlikView app.
So far the only way I've found to do this is, in Excel, to concatenate the column of values and insert a vertical bar "|" as a separator into a single cell. The user then copies that cell and pastes it into an input field in the QV app. This is a klunky and inelegant solution. Can anyone think of a way to simplify this or come up with a better scheme to use a column of Excel values as selections in a QlikView app?
Thanks for the thoughtful and clear answer. However I do need to allow the users to make the selections through the front end. Many different users use the app to search for different values from different spreadsheets, so I can't build it into the data model as you demonstrated.
Add an inputbox to your front end and add a variable vList to it.
Copy a column out of your Excel sheet where the first cell is the name of the field and the rest are the values.
Paste that into the inputbox.
IMPORTANT: When you post into the inputbox you must do this. Click on the input box then click the grey button with the ellipsis (...) so you get the edit expression screen and paste in there. If you do that the data will be pasted in as a column. If you paste straight into the inputbox the data will not be accepted as a column.
Add these variables (not in the inputbox, use the Variable Overview)
Add a button, label it Apply Filter or something. Add the action Select in Field.
for Field enter : =vField
for Search String enter : =vValues
Now try it out.
Note: If any of the selected values contain a space eg. 'Ken Dodd' the search string passed to QV will look for 'Ken?Dodd'. If you search a listbox for a value containing a space you'll see why this was done. Hopefully this will work for you.