topic Get all possible combinations in QlikView

Get all possible combinations

jvelasqu3 — Mon, 14 Nov 2022 02:05:33 GMT

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 — Mon, 14 Nov 2022 02:17:15 GMT

Hello,

do cross join

Final:

Load Name from table1;

Join

Load City from table2;

Regards,

Prashant Sangle

MayilVahanan — Mon, 14 Nov 2022 02:18:06 GMT

Load Name from table1;

Join

Load City from table2;

it will become cartesian product and give expected values.