Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today

Different Join Functions in Qlikview

Different Join Functions in Qlikview

In join functionality we have four type of the joins as we know and at the place they differently used in the data model. I provide this document for under stand the functionality of the joins in the 4 ways.

There are 4 type of joins

1. Left Join

2. Right Join

3. Inner Join

4. Outer Join

1. Left Join :- When we use this join between two tables the join occurs but the rows from the left table taken and from right table only matching rows.

2. Right Join:- When Right Join used between tables so in this only right tables rows taken and the matching rows from the left table taken.

3. Inner Join:- In this join type only matching rows from both the tables right and left table is taken.

4. Outer Join:- In this join rows taken which is not match another table.

Two Tables.png

After different Joins performance table look with different joins functionality and the number of rows is different in each tables

Different Joins.png

You can check the attached file also and go for loading different joins table for its definition at a time only one join. In the script vDefine variable is always set to 1 and for viewing different join table then set 1 for that tab variable and rest are must set as 0 in the variable. At a single time if you view only one table will give you best definition of the joins and you can see the join performs and the result in the table box for rows that loaded.

LET vDefine = 1;
LET vLeftActivator = 1;
LET vRightActivator = 0;
LET vInnerActivator = 0;
LET vOuterActivator = 0;


Regards

Anand

Attachments
Comments
Not applicable

Thanks, its a really good thing to keep everything on one document. It would be really helpful if you add Keep and Concatenate in the same Document.

Thanks

San

0 Likes

Sure i am later provide that document also.

Regards

Anand

0 Likes
Partner
Partner

Joins.. you made it very simple to understand.

Thanks

Mithilesh

0 Likes
Creator III
Creator III

Thanks. Very well explained. I was struggling to understand joins for a long time

0 Likes

Thanks for the appreciation.

Regards

Anand

0 Likes
Specialist II
Specialist II

good post

0 Likes

Thanks all for the responses, I keep posting new things to you all.

Regards

Anand

0 Likes
Contributor III
Contributor III

Good Exaplanation.

0 Likes
Contributor
Contributor

Hi,

 

I have downloaded the Joins file,but when i loaded in qlikview it is not uploading

Error: Failed to upload\Failed to open document

0 Likes
Contributor
Contributor

Hi  

can you please help me above query

 

 
0 Likes
Version history
Revision #:
1 of 1
Last update:
‎2014-11-27 02:00 PM
Updated by: