topic Re: Several fields in same list box in QlikView

Several fields in same list box

Mon, 18 Jun 2012 15:05:19 GMT

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!

Re: Several fields in same list box

Anonymous — Mon, 18 Jun 2012 15:31:52 GMT

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.

Re: Several fields in same list box

Mon, 18 Jun 2012 15:39:27 GMT

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...

Re: Several fields in same list box

Tue, 19 Jun 2012 03:58:06 GMT

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

Re: Several fields in same list box

sivarajs — Tue, 19 Jun 2012 04:31:59 GMT

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

Re: Several fields in same list box

Tue, 19 Jun 2012 18:45:23 GMT

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.