topic Main difference between Left Join and Join in QlikView

Main difference between Left Join and Join

Black_Hole — Sat, 16 Nov 2024 02:24:24 GMT

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.

dplr-rn — Tue, 24 Sep 2019 14:59:31 GMT

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

Black_Hole — Tue, 24 Sep 2019 15:17:52 GMT

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

dplr-rn — Tue, 24 Sep 2019 15:19:36 GMT

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

Brett_Bleess — Wed, 02 Oct 2019 21:40:05 GMT

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

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

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