topic Re: Filter (Ability to upload multiple values into filter to select) in QlikView

Filter (Ability to upload multiple values into filter to select)

Fri, 19 Feb 2016 21:24:25 GMT

Hi all,

Sample data set:

Company Name	Company Id
XYZ Corp	1235
ABC Inc	1234a
123 ABC Inc	5532
3X Corp	a4584
Enterprise Ltd	q451

Of course my list has thousands of values to filter from, but what the users are asking for is the ability to copy/paste a set of values...for the purpose of this example, a user wants to be able to copy/paste a list: 3X Corp Enterprise Ltd - in the filter and it select those values.

Does such a feature exist in QV to be able to copy/paste a list maybe from excel of 1,000 values and it auto-select or highlight those values? Rather than typing them in individually and still having to eyeball the list or having to filter through a list of thousands and do ctrl click for all the selections I would want to make).

Please help.

Thanks

Re: Filter (Ability to upload multiple values into filter to select)

swuehl — Fri, 19 Feb 2016 21:57:56 GMT

There are a couple of example here in the forum that demonstrate how you can copy values from e.g. Excel and use these to select values in a list box.

I had a specific example in mind, but can't find it right now.

Here is another, similar approach:

Search by copy and pasting from an external list - The Qlik Fix! The Qlik Fix!

Re: Filter (Ability to upload multiple values into filter to select)

settu_periasamy — Fri, 19 Feb 2016 22:30:05 GMT

May be this one will helps

Mass selection in list box and dynamically fill... | Qlik Community