Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
jduenyas
Specialist
Specialist

Passing multiple values to a listbox

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

1 Solution

Accepted Solutions
jduenyas
Specialist
Specialist
Author

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*)

View solution in original post

3 Replies
rwunderlich

I believe you'll need parens around the string

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


-Rob

jduenyas
Specialist
Specialist
Author

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*)

View solution in original post

jduenyas
Specialist
Specialist
Author

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

See my reply to myself.