topic Join 2 tables in QlikView https://community.qlik.com/t5/QlikView/Join-2-tables/m-p/95092#M753944 <HTML><HEAD></HEAD><BODY><P>Dear Qlikview community,</P><P></P><P>I joined 2 oracle tables (containg 4 commun fields) and 2 diffrent fields).</P><P></P><P>The problem I am facing is that I am not getting the data in the same line in the result table.</P><P></P><P>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.</P><P></P><P>The fields I want to find them on the same line are : </P><P>QTEREDCONS and QTECON.</P><P>(in order to add them using the function: NumSum(QTECON,QTEREDCONS) AS QTECONTOTALE)</P><P></P><P>Please see the attached file.</P><P></P><P>Please I need your help.</P><P></P><P>Best regards,</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT absekrafi 2020-11-25T16:16:04Z Join 2 tables https://community.qlik.com/t5/QlikView/Join-2-tables/m-p/95092#M753944 <HTML><HEAD></HEAD><BODY><P>Dear Qlikview community,</P><P></P><P>I joined 2 oracle tables (containg 4 commun fields) and 2 diffrent fields).</P><P></P><P>The problem I am facing is that I am not getting the data in the same line in the result table.</P><P></P><P>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.</P><P></P><P>The fields I want to find them on the same line are : </P><P>QTEREDCONS and QTECON.</P><P>(in order to add them using the function: NumSum(QTECON,QTEREDCONS) AS QTECONTOTALE)</P><P></P><P>Please see the attached file.</P><P></P><P>Please I need your help.</P><P></P><P>Best regards,</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Join-2-tables/m-p/95092#M753944 absekrafi 2020-11-25T16:16:04Z Re: Join 2 tables https://community.qlik.com/t5/QlikView/Join-2-tables/m-p/95093#M753945 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Thu, 11 Oct 2018 09:27:43 GMT https://community.qlik.com/t5/QlikView/Join-2-tables/m-p/95093#M753945 swuehl 2018-10-11T09:27:43Z