Wrong join? Please,help

[andradinu]

Hi everybody!

I am trying to join two tables with key,but it gives strange result. Where I am going wrong?

I have attached the qvw and qvd files.  Can someone help me?

Many thanks!

Regards

Andra

[manideep78]

Hi What is the problem there? What is the result you are expecting? Can you please tell you problem in detail?

[#3]

Hi Andra Dinu,

you need not to apply join in the script..make a common key on both qvds ,they automatically join based on that key.

PFA QVW

[kaushiknsolanki]

Hi,

     Its because the key on the basis of which you are trying to join the tables are not unique.

     for example.

     AXTRBKFC/10/2013 Key has 4 records in Budget table and 2 Records in Invoice Table.

     So when you join them it creates 8 Records and thats where the mismatch happens.

     Kindly redefine the Key to make it Unique.

Regards,

Kaushik Solanki

[#5]

Hi Andra,

Qlikview applies outer join by default if you have similar field names in 2 tables. So might be something like attached will help.

Also, if you want to display "Sum" in some other format then you can change that in "Number" tab.

Hope this helps!

[andradinu]

You're absolutely right, but it just does not know how to do this. I added the script completely in the hope that better explained