2 field values in single list box

[#1]

Hi All,

I want to display 2 fields in single list box by clubbing data in both fields. These 2 fields have some values in common and some are not common so I want to display all the values.

Thanks!!!

[#2]

Not clear.. Can you post example for same?

[senpradip007]

Try somthing like

=Field1 & '-' & Field2

[ashfaq_haseeb]

Hi you can try something like this.

load

F1,

F2,

F1&F2 as F3

from XYZ;

Regards

ASHFAQ

[swuehl]

Sorry, I don't fully understand. Could you give some sample data and what you expect?

You can use a field expression (use field drop down on general tab, select <expression> )  to concatenate the two fields:

=A & ' - ' & B

or use A as field and B as expression (on expression tab).

[israrkhan]

if i understood your requirement,

Try like

in list box properties, select Expression instead of field.

and write expression like  =Year &'  '& Month,

in list box i can see Year and month both fields...

Kind Regards

Khan

[#7]

Hi All,

Just to make my problem clear.

Usually we use a list box to display single field values by selected that field inside list box.

In my case I'm having 2 fields say A and B I want to display all possible values of A and B in single list box.

I need individual values, not concatenation of the values of 2 fields.

Attached is my sample .qvw files. In this file I'm having 2 list boxes. I want to club values displayed in these 2 list boxes into single list box.

[#8]

Hi IsrarKhan ,

Your solution will concatenate values. But I want to display the values as it is without concatenation. Basically I want union of 2 fields into one.

[#9]

Hi Pradip ,

I need union of 2 fields not fields not concatenation. Could you please help in this.

[#10]

Hi swuehl ,

I need union of 2 fields not fields not concatenation. Could you please help in this.