Solved: Get all possible combinations - Qlik Community

jvelasqu3 · ‎2022-11-13

Hi All,

I would like to obtain all possible combinations between two variables.
I currently have 2 variables, Names and Cities
Table 1:
Name1
Name2
Name3

Table 2:
City1
City2
City3

The final table should be:
Name City
Name1 City1
Name1 City2
Name1 City3
Name2 City1
Name2 City2
Name2 City3
Name3 City1
Name3 City2
Name3 City3

I'd greatly appreciate some insight on how to deal with this in QlikSense.

Many thanks,

PrashantSangle · ‎2022-11-13

Hello,

do cross join

Final:

Load Name from table1;

Join

Load City from table2;

Regards,

Prashant Sangle

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

View solution in original post

PrashantSangle · ‎2022-11-13

Hello,

do cross join

Final:

Load Name from table1;

Join

Load City from table2;

Regards,

Prashant Sangle

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

MayilVahanan · ‎2022-11-13

HI

Load Name from table1;

Join

Load City from table2;

it will become cartesian product and give expected values.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

Get all possible combinations

Scripting