Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
marksmunich
Contributor II

left join issues

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.

5 Replies
Not applicable

Re: left join issues

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.

marksmunich
Contributor II

Re: left join issues

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

jpapador
Valued Contributor

Re: left join issues

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

marksmunich
Contributor II

Re: left join issues

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.

Not applicable

Re: left join issues

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

Community Browser