I don't know why the numbers are not coming out right, but you need to realize that you are not joining (inner or left) in QlikView. The joins are taking place in SQL also. QlikView is just picking up the value of those joins and displaying them. May be something else in your script might be doing this? You have only pasted the SQL code, so difficult to see what the issue could be. But I would suggest exploring options beyond just the joins cause to me it doesn't make sense that QlikView or SQL will arbitrarily pick a value from above and display it.