topic Re: combining values from a column with another set column in Qlik Learning Discussions

combining values from a column with another set column

thanhphongle — Tue, 10 Mar 2015 09:33:31 GMT

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

Re: combining values from a column with another set column

Gysbert_Wassenaar — Tue, 10 Mar 2015 12:46:19 GMT

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

Re: combining values from a column with another set column

thanhphongle — Tue, 10 Mar 2015 13:46:32 GMT

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

Re: combining values from a column with another set column

Gysbert_Wassenaar — Tue, 10 Mar 2015 14:03:43 GMT

Combined:

LOAD * FROM data1;

Outer join(Combined)

LOAD * FROM data2;

Re: combining values from a column with another set column

thanhphongle — Tue, 10 Mar 2015 15:02:23 GMT

works! thank you!