topic Outer join doesn't work? in QlikView

Outer join doesn't work?

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Outer join doesn't work?

vishsaggi — Fri, 26 Aug 2016 19:22:31 GMT

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.

Re: Outer join doesn't work?

Fri, 26 Aug 2016 19:24:34 GMT

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

Re: Outer join doesn't work?

vishsaggi — Fri, 26 Aug 2016 19:28:37 GMT

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

Re: Outer join doesn't work?

MarcoWedel — Fri, 26 Aug 2016 20:38:10 GMT

please post an example application and describe your expected result.

thanks

regards

Marco

Re: Outer join doesn't work?

johnca — Fri, 26 Aug 2016 23:53:44 GMT

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