topic Re: JOIN in QlikView

JOIN

Mon, 23 Sep 2013 05:23:51 GMT

How Many types of joins are possible in qlikview??

i heard that only left and and outer join is possible in qlikview

plz help??

Re: JOIN

jagan — Mon, 23 Sep 2013 09:13:51 GMT

Hi,

Right join, Inner join and full outer join is also available.

check help file

Join

The join prefix joins the loaded table with an existing named table or the last previously created logical table. The join is a natural join made over all the common fields. The join statement may be preceded by one of the prefixes inner, outer, left or right.

join [ (tablename ) ]( loadstatement | selectstatement )

Regards,

Jagan.

Re: JOIN

Mon, 23 Sep 2013 09:21:08 GMT

The Qlikview Help facility in desktop would provide you with the best information on this. As Jagan stated, there are; inner, outer, left, and right joins available. Each with their own distinctive functionality.

Regards

Steve