Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
jsn
Honored Contributor

Re: Several fields in same list box

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

Re: Several fields in same list box

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

Re: Several fields in same list box

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
Valued Contributor II

Re: Several fields in same list box

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

Re: Several fields in same list box

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.

Community Browser