topic Re: Implicit join is not working in QlikView

Implicit join is not working

Wed, 11 Mar 2015 17:23:21 GMT

Hi All,

I am a QlikView learner.

I have orders, calendar tables and day_id is common field between these tables,

the values day_id is e.g. ( 20140101 , 20140102...etc).

In my calendar table i have past 5 years data , but in my orders table i have data starting from Jan-2014.

I have loaded these two tables into QlikView and click the Table View ( Ctrl+ T) , it shows join link as day_id between these tables.

The question is when i use list box for day_id column it is showing all data , which means past 5 years data.

I guess the joining in QlikView is not happening properly , if it is inner join by default .. it should not show all 5 years data from calendar table because it is inner joined with orders table , so only it show the data starting from Jan-2014.

But when i joined these two tables in scripting , it is working fine..it showing matched data only from two tables.

Please clarify me ... why it is not working implicit join when we import tables .. and it is working only when we join explicitly..

Thanks in advance !!

Sridhar Bunga

Re: Implicit join is not working

JonnyPoole — Wed, 11 Mar 2015 18:09:39 GMT

Even though day_id exists in both tables, when you use it in the UI it will show values from both tables combined. The 'link' is analagous full outer join. If you want any different kind of link do an inner or outer join in the script.

Even with full outer you can load the same field on both sides again so that you will have fields that show the values from the respective tables alone (calendardayid and orderdayid below)

Calendar:

load

day_id,

day_id as calendardayid

from <>

Orders:

load

day_id,

day_id as orderdayid

from <>

Re: Implicit join is not working

Wed, 11 Mar 2015 19:12:00 GMT

Thanks Jonathan !! I got it