topic How to paste in and select 200+ values in multibox in QlikView

How to paste in and select 200+ values in multibox

Tue, 03 Sep 2013 12:51:40 GMT

As a user I need to select 200+ values based on a string generated another place, e.g. "(64104|156154|157390|76911642|94254|94328)".

I need to do this directly in a multibox search, but it seems to be limited to a specific number of search items in the pasted list.

How can I make an expression that can select all the values?

Note that some values may not exist, notification is not necessary. It just need to select the ones matching.

Re: How to paste in and select 200+ values in multibox

Gysbert_Wassenaar — Tue, 03 Sep 2013 12:54:40 GMT

I don't think you'll get the multibox to accept more characters. Try using an input box to store the input string into a variable. You can use the OnInput variable trigger to execute an Select in Field action using the variable value as search string, i.e. the string with the values.

Re: How to paste in and select 200+ values in multibox

Tue, 03 Sep 2013 12:55:58 GMT

Will that extend the number of accepted search items in a search string?

Re: How to paste in and select 200+ values in multibox

rajeshvaswani77 — Tue, 03 Sep 2013 12:57:20 GMT

Hi Andreas,

If you can manage to input this, it will work.

"64104","156154","157390","76911642","94254","94328"

Not so sure if this is what you are looking for?

thanks,

Rajesh Vaswani

Re: How to paste in and select 200+ values in multibox

Tue, 03 Sep 2013 13:00:41 GMT

What if I'm not allowed to create variable, will the expression you mentioned work in a advanced search of the multibox?

Re: How to paste in and select 200+ values in multibox

Gysbert_Wassenaar — Tue, 03 Sep 2013 13:04:33 GMT

It should. See this discussion.

Re: How to paste in and select 200+ values in multibox

rajeshvaswani77 — Tue, 03 Sep 2013 13:11:30 GMT

Yes thats right. You do not use variable, you can use this on the search control as well if your field is added there.

thanks,

Rajesh Vaswani

Re: How to paste in and select 200+ values in multibox

Tue, 03 Sep 2013 13:29:10 GMT

When using normal search in the multibox, the string is simply too long, it will not accept it all.

In "Advanced Search" when I add the expression and click "go" nothing is selected and the expression is underlined with red.

Re: How to paste in and select 200+ values in multibox

pelqlikview — Thu, 19 Sep 2013 13:09:50 GMT

We developed a document extension which enables users to paste as much entries as they like from their clipboard to any listbox on the sheet.

They furthermore have the choice of:

Selecting in wildcard or explicit mode and
To add a dynamic number zeroes before the actual value.

Because of restrictions in the JS API it won't work with multiboxes though. The listboxes however can be defined as small as multibox elements.

If this is of interest to you please feel free to contact me via email. We will up this development to the Qlikmarket soon.