Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

JOINS by default ?


I want to know which JOIN qlikview do by default ?

Many thanks

2 Replies
Valued Contributor III

Re: JOINS by default ?

Here is an extract from QlikView Reference Manual that has answerto your question.


The simplest way to make a join is with the join prefix in the script, which

joins the input table with the last previously created logical table. The join

will be an outer join, creating all possible combinations of values from the

two tables.


JOINS by default ?

Not that you have to, but I prefer to always explicitly state which sort of join I want, even for an outer join.  I think the code is more clear that way.

Community Browser