Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!!
Not clear.. Can you post example for same?
Try somthing like
=Field1 & '-' & Field2
Hi you can try something like this.
load
F1,
F2,
F1&F2 as F3
from XYZ;
Regards
ASHFAQ
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).
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
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.
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.
Hi Pradip ,
I need union of 2 fields not fields not concatenation. Could you please help in this.
Hi swuehl ,
I need union of 2 fields not fields not concatenation. Could you please help in this.