Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Passing large list of values into listbox

I am looking to pass through a large list of values into a listbox filter (around 700 specific values), and I can't think of a better way to do this than the standard (*1*|*2*|*3*) approach, which fails in this case because the list of values (which are all 6 digit numbers) is simply too long.

Is there any way of passing through a substantial list of csv values into a listbox without changing the loading script / dashboard design?

Thanks!

3 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: Passing large list of values into listbox

See attached qvw. Works with at least 850+ six digit values so it should work for you.


talk is cheap, supply exceeds demand
Highlighted
Not applicable

Re: Passing large list of values into listbox

Thanks for attaching an example - however the list of values is being entered into an inputbox (and has an associated variable) - is there any way of doing this with native listboxes instead?

In my specific case it is probably not feasible to change the filtering from standard listboxes, so it would be good to know if anything can be done in this case

Highlighted
Employee
Employee

Re: Passing large list of values into listbox

You may want to consider the copypaste extension.  See this post

Best way to specify large number of filter values?