1 Reply Latest reply: Oct 11, 2018 5:27 AM by Stefan Wühl RSS

    Join 2 tables

    Abdallah Sekrafi

      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,