Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

zekazak
Contributor

The best way of linking two tables

Hello,

I've got a question about what's the best way of linking two tables like this:

Table 1 - Sales:

CR_IDORD_IDQTY
1234561
1254565
1275677

Table 2- Options

CR_IDORD_IDOPT
123456a
123456b
123456c
125456a
127567b

Is this the best solution to link them on CR_ID if people want to report on OPT field? For example, they want to select one or combination of options to see the total QTY or count of orders with this option or particulatr combimation of options.

Thank you in advace,

~Serg

2 Replies
shree909
Valued Contributor II

Re: The best way of linking two tables

if u want to report on opt field do the right join

table 1:

table2:

right join(table 1)

by doing this u will get all the opt values ...

or else if u want all the combination   just get rid  right and it will be a outer join.......

table 1:

table2:

join(table 1)

zekazak
Contributor

Re: The best way of linking two tables

Hi,

Thanks for the quick reply.

But what if I just do "Unqualify CR_ID;" in both tables? Will it be enought?

Best Regards,

Serg

Community Browser