use of join

[Anonymous]

hello,

i get one requirement to find returned sales.

i have two table order and return, return

order:

Order ID	Order Date	Ship Date	Region	Sales
CA-2012-124891	7/31/2012	7/31/2012	East	2309.65
IN-2013-77878	2/5/2013	2/7/2013	Oceania	3709.395
IN-2013-71249	10/17/2013	10/18/2013	Oceania	5175.171

return :

Returned	Order ID	Market
Yes	MX-2013-168137	LATAM
Yes	US-2011-165316	LATAM
Yes	ES-2013-1525878	EU

i want find which region has returned product and their order date by using join.

thank you.

[MK9885]

With above data I do not see any result coming out as Order ID in both tables are different.

I guess if they are same, you won't have to do any joins. The Tables would map automatically by making Order ID as the key, which seem to be unique.

[stabben23]

If this is all Your Fields in Your tables, just reload and everything will Works. Qlikview will do a datamodel linked by Order ID Automatic.

[Anonymous]

i am taking only 3 rows out of 60000.

[Anonymous]

i want to show in a chart

[MK9885]

I agree with Staffan.

You do not have to do any joins. Just reload it as it is and key would be formed from Order ID in both tables.

[stabben23]

Thats the second step, first do the model, then the Charts.

[stabben23]

If you have 1 or 10000000 rows, nothing will change here, just reload Your data.

[Anonymous]

i means to say both order id have same value.

[Anonymous]

ok but in my requirements we have to used join ..