topic Re: Association and Full outer join - non key fields in QlikView

Association and Full outer join - non key fields

Mon, 06 Apr 2015 07:58:17 GMT

Hello All,

PFB the scenario.

t1:

load * inline

[

];

// outer join(t1)

load * inline

[

id, time

1, t1

1, t2

];

-**********************************************-

The above dataset when we leave the tables as such and let them associate based on id, the count(id) is 2.

whereas when we give a join(full outer) the count(id) is being shown as 4.

So, association is not same as full outer join in this case?

Need your thots on this.

Regards,

Priya

Re: Association and Full outer join - non key fields

petter — Mon, 06 Apr 2015 08:34:33 GMT

You are right: Association and Outer Join is not the same.

Sometimes they are sometimes they are not. Henric Cronström has explained that on this forum I remember. He explained that associations are quite a bit more dynamic so it is not only how the data are associated in the data model but also how the selections are made that determine the results you get in the user interface. So in some cases it might even be a left join depending on the charts composition and the selections...

Re: Association and Full outer join - non key fields

buzzy996 — Mon, 06 Apr 2015 09:45:55 GMT

in roughly, Association will happen based on same field names automatically but joins(outer) will happen based on data.

Re: Association and Full outer join - non key fields

Mon, 06 Apr 2015 13:16:09 GMT

Thanks for the reply.

Could you please share the explanation by Henric Cronström?

Searched for it, but couldnt get the post.

Thanks!

Re: Association and Full outer join - non key fields

buzzy996 — Mon, 06 Apr 2015 13:21:42 GMT

hopes i'm not wrong here,the explanation is same as I SAID ABOVE