topic Re: Left Join in QlikView

Left Join

vsharma1 — Wed, 25 Nov 2020 16:16:04 GMT

when should we use left join in Qlikview?

Re: Left Join

yogiachilleos — Sun, 02 Jun 2019 12:29:22 GMT

Howdy Vsharma1,

When do you need to breathe? When do you need to drink? When do you need to answer vague questions with vague answers:

When you need to! 😄

This is almost impossible to answer through texts. Here is a great video by Abhishek that better describe their use:

https://www.youtube.com/watch?v=T_NZY1I2-zU

Hope that helps!

Kind regards,

Yogi Achilleos

Re: Left Join

vsharma1 — Wed, 05 Jun 2019 15:04:12 GMT

are we using join just to make data model simpler?

Re: Left Join

Brett_Bleess — Wed, 03 Jul 2019 20:55:00 GMT

It would be possible to use it to make the data model more efficient, hopefully that puts things into a better perspective, as if you have two tables that have the same number of rows with a delta of only a few columns, then it is going to likely be much more efficient to use a JOIN to make the two tables a single table... Hopefully this helps a bit more.

Regards,
Brett

Re: Left Join

vsharma1 — Fri, 05 Jul 2019 03:05:34 GMT

Ok, Thank you