topic Re: Wrong join? Please,help in QlikView

Wrong join? Please,help

andradinu — Wed, 11 Dec 2013 23:13:30 GMT

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 — Thu, 12 Dec 2013 05:05:49 GMT

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

Thu, 12 Dec 2013 06:00:15 GMT

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 — Thu, 12 Dec 2013 06:06:55 GMT

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

Thu, 12 Dec 2013 06:08:22 GMT

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 — Thu, 12 Dec 2013 11:19:57 GMT

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