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 :


      (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,