Join 2 tables

[absekrafi]

Dear Qlikview community,

I joined 2 oracle tables (containg 4 commun fields) and 2 diffrent fields).

The problem I am facing is that I am not getting the data in the same line in the result table.

I want the data to be on the same line when the commun field values are the same, because I am adding 2 fields using the NumSum() function.

The fields I want to find them on the same line are :

QTEREDCONS and QTECON.

(in order to add them using the function: NumSum(QTECON,QTEREDCONS) AS QTECONTOTALE)

Please see the attached file.

Please I need your help.

Best regards,

[swuehl]

What if there are multiple records (see line 9-13)? If you want to aggregate the records, use a group by clause and an aggregation function in your script, your initial request will also be solved then.