Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Combined:
LOAD * FROM data1;
Outer join(Combined)
LOAD * FROM data2;
I have no idea what you want. Perhaps you can use attached qvw to explain.
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
Combined:
LOAD * FROM data1;
Outer join(Combined)
LOAD * FROM data2;
works! thank you!