Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Several fields in same list box

Hi community,

For complicated reasons I had to load some data into my document in three seperately named fields.  I would like to include the values from all 3 of these fields in the same listbox.  Is that possible and how?

Thank you!

5 Replies
Anonymous
Not applicable
Author

Well, not really. I think it'll be easier to try and sort out to get the data needed for one listbox into one field.. or use several listboxes.

Not applicable
Author

Do you know how I would concatenate those tables?  I have 3 separate tables each with its own field that I'd like to concatenate. Like:

Table 1:

load field1

FROM...

Table 2:

load field2

FROM...

Table 3:

load field3

FROM...

Not applicable
Author

Hi Brandon,

Could you be more specific in your problem? There are several ways to concatenate tables. Not sure what you really want. Hi Johannes!

Regards,

Xue Bin

sivarajs
Specialist II
Specialist II

you use like

tab1:

load field1 as com_field,

  'A' as type

from filepath;

tab2:

load field2 as com_field,

  'B' as type

from filepath;

tab3:

load field3 as com_field,

  'C' as type

from filepath;

com_field have all your fields using type you can identify which field

Not applicable
Author

You can select a value from three different fields in a single list box. Create a list box and in the properties, instead of choosing a field name, choose <expression>. Then, in the expression dialog box, try this:    ='my field1=' & MYFIELD1 & ' my field2=' & MYFIELD2 & ' my field3=' & MYFIELD3             then click OK. You will then have a list box that shows all of the combinations of the three field values that occur in the data. A single click on the values shown in the list box selects the corresponding value from each of the three fields at once.  You should put a meaningful title into the listbox and, if needed, adjust the list box sort to sort on one of the fields.