combining values from a column with another set column

[thanhphongle]

Hello community,

is there a possibility to combine particular values from a [COLUMN A] with an other complet [COLUMN B]?

Excample:

First Column

Car Category
Truck
Roadster
Bus
Normal car
Motor Bike

Second Column

Manufacturer
Mercedes
BMW
Honda
Porsche
Toyota

What I like to do is,

selecting Truck from the first column and combine it completly  with Manufacturer

->   Truck-------> Mercedes

                        BMW

                        Honda

                        Porsche

                        Toyota

then selecting Roadster

->   Roadster--> Mercedes

                        BMW

                        Honda

                        Porsche

                        Toyota

and Bus

->   Bus---------> Mercedes

                        BMW

                        Honda

                        Porsche

                        Toyota

etc

at the end it should show me for each value of the first column the list of manufacturer which i can select for a presentation view

[Gysbert_Wassenaar]

I have no idea what you want. Perhaps you can use attached qvw to explain.

[thanhphongle]

well i have 2 data

Data 1 has got {1,2,3,4} as values.

Data 2 has got {a,b,c,d} as values

i want to combine

value 1 from Data1 has got the values a,b,c,d

value 2 from data1 has got the values a,b,c,d

etc

in the upper excample it should be something like this

in the data of car category

i have e.g. motorbikes. but i have motorbikes from Mercedes, BMW, Porsche, Honda and Toyota.

so in qlikview it should show me, whn i select motorbikes in the listbox it should give me out all manufacturer in a listbox

e.g             

Car Category

Truck

Roadster

Bus

Normal car

Motor Bike

        --------------------------->   Manufacturer

                                        Mercedes

                                        BMW

                                        Honda

                                        Porsche

                                        Toyota

i m sorry, but i cant attached a qvw file. i just need the expression how to combine those values

[Gysbert_Wassenaar · Accepted solution]

Combined:

LOAD * FROM data1;

Outer join(Combined)

LOAD * FROM data2;

[thanhphongle]

works! thank you!