topic Re: left join issues in QlikView

left join issues

marksmunich — Mon, 13 May 2013 14:05:08 GMT

I have created a a table using the inline . i hvae 3 columns in it, where is the last column has the value for the no of planned hours like 600, 400, 600 etc. this table has 6 rows. i have performed a left join fo this table to the fact table using a left join. which has other fields such as no of worked hours. the total planned hours is 2800 hours per year . in a bar chart i have tried to display the planned hours and work hours, but something is going wrong with the planned hours column which i have created using inline. it is unable to display its value in either lists or in the bar charts.

Re: left join issues

Mon, 13 May 2013 14:29:59 GMT

Hi,

Make sure that you have applied left join based on primary key i.e unique and not null field.

And that field name should be the same in both the tables.

You can't left join on the basis of planned hours(this is not unique field).

Hope this helps you.

Re: left join issues

marksmunich — Mon, 13 May 2013 15:24:04 GMT

It is based on the unique key and none of the values are null.

Re: left join issues

jpapador — Mon, 13 May 2013 20:01:06 GMT

Does the unique key from your inline table have matching values in the key field of the table you are joining to?

Re: left join issues

marksmunich — Tue, 14 May 2013 10:24:33 GMT

yes it does have. only then its possible to join. i have joined as well. In the resultant table, the newly added table colum has total null values.

Re: left join issues

Tue, 14 May 2013 10:42:04 GMT

check left join in correct way some time may u join with right table