Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

JOIN

How Many types of joins are possible in  qlikview??

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

plz help??

Labels (1)
1 Solution

Accepted Solutions
jagan
Partner - Champion III
Partner - Champion III

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.

View solution in original post

2 Replies
jagan
Partner - Champion III
Partner - Champion III

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.

Not applicable
Author

Hi

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