Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Outer join doesn't work?

Hello

I have a problem with an outer join and i can't fix it.

I have two tables with two fields in common, the relation is ok and it's working. i have a few numbers and the sum of them is ok

Now, when i write "Outer Join" i do the same sum and i'm having a larger amount. I don't understand why this is happening. Shouldn't the outer join keep the relation?

Greetings

5 Replies
vishsaggi
Esteemed Contributor III

Re: Outer join doesn't work?

Look here:

Understanding Join, Keep and Concatenate

Outer Join:

And also outer join gives all values from left table and all values from right table and any non matching values will also be displayed.

Highlighted
Not applicable

Re: Outer join doesn't work?

I understand outer join. You're not answering my question, please read it and if you don't understand me you can say it.

vishsaggi
Esteemed Contributor III

Re: Outer join doesn't work?

Can you explain little more please ? or a sample to share with the issue ?

Re: Outer join doesn't work?

please post an example application and describe your expected result.

thanks

regards

Marco

johncaqc
Valued Contributor

Re: Outer join doesn't work?

The relationship with an outer join is indeed maintained between the tables. Why an outer join creates a higher sum is interesting. As suggested by Marco, please post an example of your data and results.

--john