Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi What is the problem there? What is the result you are expecting? Can you please tell you problem in detail?
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
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
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!
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