Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
master_student
Creator III
Creator III

join

Hello Guys,

A join in qlikview is equivalent to outer join or inner join?

Thanks

2 Replies
mayankraoka
Specialist
Specialist

By default it is outer join.Creating all possible combinations of values from thetwo tables.

Prefer to always explicitly state which sort of join you want, even for an outer join. The code is more clear that way.

Regards,

Mayank

kalyanivintha1
Creator II
Creator II

Hi,

I think....

Outer join is equivalent to join...

because..join is not going to filter the data it just append the both tables fields into single table,if there is any common fields join will merge that filed data and other fields just append into first table.

and

where as in inner join it is going to filter the data based on link filed ,if suppose there no link filed it will treated as a  normal join.

and

where as in outer join is not going to filter the data it just append the both the tables as like normal join.