Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save $300 - Register for QlikWorld (formerly Qonnections) by January 31st: Learn More
Highlighted
crichter14
Contributor

For Qlik Sense - Associated Tables

When Qlik Sense associates tables in the load script, does QS treat the two tables as having an OUTER JOIN, INNER JOIN, LEFT JOIN, RIGHT JOIN?

I've been assuming Outer Join, but would like someone to verify, please.

2 Replies
Partner
Partner

Re: For Qlik Sense - Associated Tables

Default Outer join, if join with just keyword JOIN.  There is also another variation Keep when compared to SQL server joins.

https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/Scripting/combine-tables-join-keep...

Partner
Partner

Re: For Qlik Sense - Associated Tables

Yes Qlik associates as default outer join unless we specify.