topic Re: Passing multiple values to a listbox in QlikView

Passing multiple values to a listbox

jduenyas — Thu, 13 Nov 2014 18:31:26 GMT

Hi all

How do I pass a list of multiple items to a list box?

I have a button that generates a list of months (YTD, or Last 12 months etc.) and I wish to pass them to a list box.

The list is delimited with a '|' (Pipe) and it is saved in a variable. If Pipe is not the right delimiter what should the delimiter be?

This is the list I have now in the variable: Jan|Feb|Mar|Apr|May|Jun|Jul|Aug|Sep|Oct

I then use "Select in Field" and set the Search string as the variable

I tried numeric values as well but no luck

Re: Passing multiple values to a listbox

rwunderlich — Thu, 13 Nov 2014 18:41:41 GMT

I believe you'll need parens around the string

(Jan|Feb|Mar|Apr|May|Jun|Jul|Aug|Sep|Oct)

-Rob

Re: Passing multiple values to a listbox

jduenyas — Thu, 13 Nov 2014 18:45:45 GMT

OK I figured it out

The list should start with an opening Parenthesis and end with a closing parenthesis and the delimiter should be set to *|* (Star Pipe Star) The list should look like this:

(*Jan*|*Feb*|*....*|*Nov*|*Dec*)

Re: Passing multiple values to a listbox

jduenyas — Thu, 13 Nov 2014 18:47:07 GMT

Thanks Rob (I appreciate your replies to all, all the time)

See my reply to myself.

Re: Passing multiple values to a listbox

dmohanty — Thu, 20 Jan 2022 05:24:14 GMT

@rwunderlich - hope you are good!

How to get the display in Current Selection Box as Jan, Feb, Mar, Apr etc. , instead of (Jan|Feb|Mar|Apr|May|Jun|Jul|Aug|Sep|Oct) ?

Just like regular List Box selection display.

Re: Passing multiple values to a listbox

rwunderlich — Thu, 20 Jan 2022 15:14:23 GMT

That just seems to be the way the selection is stored. I don't know of any way around it. The only workaround I can think of would be to make your own current selections display by using GetCurrentSelections and parsing the x|y values.

-Rob