Left Join

[vsharma1]

when should we use left join in Qlikview?

[yogiachilleos]

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

[vsharma1]

are we using join just to make data model simpler?

[Brett_Bleess]

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

[vsharma1]

Ok, Thank you