topic Null values after a JOIN in QlikView https://community.qlik.com/t5/QlikView/Null-values-after-a-JOIN/m-p/64831#M773340 <HTML><HEAD></HEAD><BODY><P>Dear Qlikview community,</P><P></P><P>I did a normal JOIN on 2 tables but I got the mesures fields shifted to where there is no corresponding value of the dimensions.</P><P></P><P>My mesures are: QTEPROD, QTEREDPROD and QUANTPRODTOTAL</P><P>and my dimensions are: CODUSN, CODEMP, CODESMP, CODPROD, CODSPROD, TYPEART AND TRANSCATION DATE.</P><P></P><P>Enclosed the table boxes of both Tables.</P><P></P><P>Do I have to use an other type of JOIN?</P><P></P><P>Please help me.</P><P></P><P>Thank you in advance,</P><P>Abdallah</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT absekrafi 2020-11-25T16:16:04Z Null values after a JOIN https://community.qlik.com/t5/QlikView/Null-values-after-a-JOIN/m-p/64831#M773340 <HTML><HEAD></HEAD><BODY><P>Dear Qlikview community,</P><P></P><P>I did a normal JOIN on 2 tables but I got the mesures fields shifted to where there is no corresponding value of the dimensions.</P><P></P><P>My mesures are: QTEPROD, QTEREDPROD and QUANTPRODTOTAL</P><P>and my dimensions are: CODUSN, CODEMP, CODESMP, CODPROD, CODSPROD, TYPEART AND TRANSCATION DATE.</P><P></P><P>Enclosed the table boxes of both Tables.</P><P></P><P>Do I have to use an other type of JOIN?</P><P></P><P>Please help me.</P><P></P><P>Thank you in advance,</P><P>Abdallah</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Null-values-after-a-JOIN/m-p/64831#M773340 absekrafi 2020-11-25T16:16:04Z