Joins between tables in QlikView

[#1]

Hi,

I am Ravikumar from "Ajzaas Solutions"

help me how to use joins between two tables in qlikview with brikef explanation....

[#2]

You can see from here join types. It's sql join types but it will give you fully understand type of joins.

http://mssqlonline.blogspot.com/2009/04/sql-server-introduction-to-joins-basic.html

Join types in QV you can see it from QV help(F1).

Hope it's help you bit.

[amars]

Hi Ravi,

Qlikview uses associative law to join different tables in qlikview. Associative law means it uses common field Name or Aliases to join different tables. You can see the Table structure formed by File -> Table Viewer or by pressing Ctrl + T.

To join the different tables you can use (Left/Right/Inner/Outer) Join (TableName To Join) Load/Select Statement;

You can see the Qlikview reference manual for the detailed description of it.

[ashfaq_haseeb]

Hi

Just go through the Document attached.

Hope that helps

Regards

ASHFAQ