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.
adoteykwame
Contributor

Issue with Left join

  Hi,

When I left join Table 2 to Table 1  the Amount becomes null any particular reason.

Table 1                    Table 2

ID                               ID

Branch                        Amount

Dept

Date

11 Replies
er_mohit
Honored Contributor II

Re: Issue with Left join

see the attached file

hope it helps

calvindk
Contributor III

Re: Issue with Left join

Probably because there are no overlapping ID's and you are doing left join

If there are overlapping ID's double check that the formatting is the same.

Not applicable

Re: Issue with Left join

Dont use a table alias for the 2nd table. Please see attached mate

Cheers,

Byron

adoteykwame
Contributor

Re: Issue with Left join

Hi,

Table 1                    Table 2               Table 3                        Table 4

ID                               ID                    CID                                CID

Branch                       Amount              ID                                Balance

Dept                                                   Dept

Date                                                    Date

Table 1  (LEFT JOIN ) Table 2  (CONCATENATE) Table 3  LEFT JOIN Table 4 

Now the Balance becomes a null field but when I remove the concatenate the Balance has values. And I want just a big FACT Table.

Not applicable

Re: Issue with Left join

Originally you gave us 2 tables to work with now you have 4. If your requirement has changed please let me know exactly what you working with and what your desired output would be, then I can put something together for you

Not applicable

Re: Issue with Left join

reason is that no any id are common in both table. so amount display null.

Not applicable

Re: Issue with Left join

(thumbsup)

adoteykwame
Contributor

Re: Issue with Left join

Sorry about that initially I thought it was overlapping ID's as Anders Møller stated but i realised it has to do with the model. The above is the requirement I went to merge all into one Fact Table as the desired output.But it seems the Balance field becomes null when i use my approach.Help

adoteykwame
Contributor

Re: Issue with Left join

But there is CID in Both Table 3 and Table 4...........so when i select CID is should relate to the Balance right?

Community Browser