Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Black_Hole
Creator II
Creator II

Main difference between Left Join and Join

Hello all,

Working in a QVW's script, I noted that when I used a left join instead of a simple join, the rows of my straight table are duplicated.

So, finally to avoid this issue, I modify by replacing the left join by the join.

But, I wonder if this kind of modification is due to a bad practice in the corpse of my script.

And in addition, if this may have an impact in the calculation result between columns in the script.

 

Thank you in advance for any explanation about this subject.

 

 

Labels (2)
2 Solutions

Accepted Solutions
dplr-rn
Partner - Master III
Partner - Master III

the choice of join depends on your data. and joins in qlik are similar to joins in standard sql. so something like below

img_innerjoinimg_leftjoinimg_rightjoinimg_fulljoin

use below url to get some more details or check qlik help site

https://community.qlik.com/t5/QlikView-Creating-Analytics/Understanding-Join-Keep-and-Concatenate/td...

View solution in original post

Brett_Bleess
Former Employee
Former Employee

Just a couple of links from Design Blog area that may help in addition to what Dilip already gave you:

https://community.qlik.com/t5/Qlik-Design-Blog/To-Join-or-not-to-Join/ba-p/1463102

https://community.qlik.com/t5/Qlik-Design-Blog/Don-t-join-use-Applymap-instead/ba-p/1467592

Feel free to search around there yourself using the following link:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Do not forget to give Dilip credit for help either, if that did help, use the Accept as Solution button on his post to mark things.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.

View solution in original post

4 Replies
dplr-rn
Partner - Master III
Partner - Master III

the choice of join depends on your data. and joins in qlik are similar to joins in standard sql. so something like below

img_innerjoinimg_leftjoinimg_rightjoinimg_fulljoin

use below url to get some more details or check qlik help site

https://community.qlik.com/t5/QlikView-Creating-Analytics/Understanding-Join-Keep-and-Concatenate/td...

Black_Hole
Creator II
Creator II
Author

Hi @dplr-rn ,

Thank you for sharing the link, I will go to see ...

dplr-rn
Partner - Master III
Partner - Master III

glad to help. mark as answered to close the thread if you dont have any further questions

Brett_Bleess
Former Employee
Former Employee

Just a couple of links from Design Blog area that may help in addition to what Dilip already gave you:

https://community.qlik.com/t5/Qlik-Design-Blog/To-Join-or-not-to-Join/ba-p/1463102

https://community.qlik.com/t5/Qlik-Design-Blog/Don-t-join-use-Applymap-instead/ba-p/1467592

Feel free to search around there yourself using the following link:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Do not forget to give Dilip credit for help either, if that did help, use the Accept as Solution button on his post to mark things.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.