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.

[stabben23]

Then you will have a Perfect match between Your keys.

In chart, use Count({<Returned={'Yes'}>}Order ID) With Region and Order Date as Dimension.

[Or]

If your requirement is to use join, use join - there's not really a question here in that case.

Load Table1;

JOIN

Load Table2;

[MK9885]

Prachi, Once you load your data and if the field names are same it would automatically make a link between 2 tables.

Plus if the values are same then it would be a key and your model would work good.

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	CA-2012-124891	LATAM
Yes	US-2011-165316	LATAM
Yes	ES-2013-1525878	EU

In above case Order ID from Order table and Order ID from return would make a link based on Order ID.

And CA-2012-124891 would come as Returned- Yes cus they both have same Order ID value.

[stabben23]

If you HAVE to use join, then use left Join (order) infront of Return table.

But, Qlikview Association, Applymap and concatenate will also do the job for you.

[MK9885]

Use Outer Join.

thats the default join in Qlik.

It would keep all the values in both the tables

Different Join Functions in Qlikview

Check the above link and do as per your need.