help me with LeftJoin - Qlik Community

JJW94 · ‎2019-10-23

I need a help with left join

From[~~.qvd]

(qvd);

I want the "date" from crime2015 to be left joined with crime2014.

But when i load the data, "date" doesn't show up.

Could you guys help me?

Lisa_P · ‎2019-10-23

We need more information to help

Brett_Bleess · ‎2019-10-31

Agree with Lisa, but here are a couple of Design Blog links that may help:

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

Lastly, the Help for Join:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/Scrip...

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.