Creating a new dimension based on two other dimensions

[EdgarB]

Hello Qlikers, 

I don't know if it is the place to ask this question. I hope somebody knows the answer.

I have two dimensions Col1  and Col2 from the same table : 

Col1	Col2
A	Z
B	Y
C	Z
D	X

And i want to create a new dimension Col3 which looks like this : 

Col3

A

B

C

D

Z

Y

X

 How can I get this new dimension with set analysis ? And Within the load script  ?

The final goal is put all values of Col1 and Col2 in a filter visualisation as if it was one unique column. 

Thank you very much. 

Ed

[EdgarB]

https://community.qlik.com/t5/QlikView-App-Dev/Combining-values-from-multiple-dimensions-in-one-axis... I think this close from the solution I am looking for but I can't manage to fix it with my example.  

[EdgarB]

I think this : https://community.qlik.com/t5/QlikView-App-Dev/Combining-values-from-multiple-dimensions-in-one-axis...

is close to the solution I am looking for but I can't manage to project it to my example. 

[EdgarB · Accepted solution]

=pick(match($Field,'Market','Market Type'),[Market],[Market Type])