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

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
jayaseelan
Creator III
Creator III

Explain Difference between join and inner join in qlik view

I have an confusion between join and inner join. Explain me briefly.

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

The default join in Qlikview and Qlik Sense is an outer join. If you don't specify which type of join you want to use then the result is an outer join. See this document for example: Different Join Functions in Qlikview


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

The default join in Qlikview and Qlik Sense is an outer join. If you don't specify which type of join you want to use then the result is an outer join. See this document for example: Different Join Functions in Qlikview


talk is cheap, supply exceeds demand
jayaseelan
Creator III
Creator III
Author

Got so idea.Thank you for the explanation.

Anonymous
Not applicable

JOIN IN THE QLIKVIEW TO COMBINE THE TWO TABLE SHOW THE ONW TABLE IN THE INTERNAL TABLE VIEW AND KEEP IS TWO SEPARTELY SHOW IT SEPARTELY