Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Joins

Hi,

what are the types of joins with examples.

@Sub2u

7 Replies
Not applicable

Re: Joins

go through this linked file

Joins and Lookups.pdf

vishalwaghole
Valued Contributor II

Re: Joins

Hi,

Left Join

Right Join

Outer Join

If you not mention any join then qlikview automatically find same column name and join them

Outer join is default join in QlikView.

-- Regards,

Vishal Waghole

Not applicable

Re: Joins

Thanks Vishal

Not applicable

Re: Joins

Thanks Bhawna

Not applicable

Re: Joins

Bhawna,

I am trying to download, but it was getting error. colud please reattach once....

@Sub2u

Not applicable

Re: Joins

Vishal,

Can u please explain with one example if possible...

I hope there is no equi join, then how will you get common columns from both the tables ....

@Sub2a

vishalwaghole
Valued Contributor II

Re: Joins

Hi,

Please have look at this image, this will help you to understand join in QlikView.

-- Regards,

Vishal Waghole

Community Browser