Qlik Community

QlikView Documents

Documents for QlikView related information.

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
sanjyotpatkar
Contributor 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
nihhalmca
Valued Contributor II

good post

0 Likes

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

Regards

Anand

0 Likes
ysj
Contributor

Very easy way to understand joins.

0 Likes
hussainbahsa
New Contributor III

Good Exaplanation.

0 Likes
saibharath199
New 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
Version history
Revision #:
1 of 1
Last update:
‎2014-11-27 02:00 PM
Updated by: