
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Tags:
- qlikview_scripting
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
the choice of join depends on your data. and joins in qlik are similar to joins in standard sql. so something like below
use below url to get some more details or check qlik help site
.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
the choice of join depends on your data. and joins in qlik are similar to joins in standard sql. so something like below
use below url to get some more details or check qlik help site

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @dplr-rn ,
Thank you for sharing the link, I will go to see ...

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
glad to help. mark as answered to close the thread if you dont have any further questions
.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
