Hi all. So I've come up with a way to filter a field by pasting in a column from an Excel spreadsheet. What I found was that I could create a variable, I'll call it ExcelFilter. I then went to Document Settings > Triggers, and created an OnInput action for that variable. I created a Select in Field action to filter the field in question, and in the search string I put this:
='(' & replace(replace(trim(ExcelFilter), '
','|'),' ','|') & ')'
Then, I just created an Input Box object and tied it to ExcelFilter. So now, I can take an Excel spreadsheet, highlight and copy a column that corresponds to the field I want to filter, paste it into the Input Box, and it will filter down the field to the list I pasted in, one value per row.
Now, this worked at first, but then I realized that if I pasted in too many rows, it would crash QlikView. I'm not sure exactly what the limit is, but it's somewhere around 5000 values. I don't know why this is happening, and I'm fairly certain that this wasn't always the case. When I first started playing with it a couple weeks ago it was working with a large number of rows. Now, for some reason, it crashes both in IE and on the desktop. Any ideas? Thanks for the help!
Eric
