topic Re: Incomprehensible result in QlikView https://community.qlik.com/t5/QlikView/Incomprehensible-result/m-p/472524#M566297 <HTML><HEAD></HEAD><BODY><P>Your data contains duplicate records. QV doesn't show duplicates, so you can only see it because the count and sum of AFFECTE are 2 instead of 1.</P></BODY></HTML> Wed, 28 Nov 2012 12:47:29 GMT Gysbert_Wassenaar 2012-11-28T12:47:29Z Incomprehensible result https://community.qlik.com/t5/QlikView/Incomprehensible-result/m-p/472523#M566296 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I need help to understand very incomprehensible result in chart (the document attached)</P><P></P><P>I have 2 tables, linked by the column FAMILLE_NUM</P><P>The column "AFFECTE" is equal to 0/1</P><P>When I select some families (for example ), the result of the expression sum(AFFECTE) is 2, whereastheres is just one family xho is selected</P><P></P><P>Please, Help</P><P></P><P>That is te first time I see something like tthis</P><P></P><P>Laurent</P></BODY></HTML> Wed, 28 Nov 2012 12:22:52 GMT https://community.qlik.com/t5/QlikView/Incomprehensible-result/m-p/472523#M566296 Anonymous 2012-11-28T12:22:52Z Re: Incomprehensible result https://community.qlik.com/t5/QlikView/Incomprehensible-result/m-p/472524#M566297 <HTML><HEAD></HEAD><BODY><P>Your data contains duplicate records. QV doesn't show duplicates, so you can only see it because the count and sum of AFFECTE are 2 instead of 1.</P></BODY></HTML> Wed, 28 Nov 2012 12:47:29 GMT https://community.qlik.com/t5/QlikView/Incomprehensible-result/m-p/472524#M566297 Gysbert_Wassenaar 2012-11-28T12:47:29Z Re: Incomprehensible result https://community.qlik.com/t5/QlikView/Incomprehensible-result/m-p/472525#M566298 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Thank for your response</P><P></P><P>What expression can I use in order to have the good result ?</P></BODY></HTML> Wed, 28 Nov 2012 14:20:24 GMT https://community.qlik.com/t5/QlikView/Incomprehensible-result/m-p/472525#M566298 Anonymous 2012-11-28T14:20:24Z Re: Incomprehensible result https://community.qlik.com/t5/QlikView/Incomprehensible-result/m-p/472526#M566299 <HTML><HEAD></HEAD><BODY><P>You can add the distinct keyword to the expressions: sum(<STRONG>distinct </STRONG>AFFECTE).</P></BODY></HTML> Wed, 28 Nov 2012 14:53:36 GMT https://community.qlik.com/t5/QlikView/Incomprehensible-result/m-p/472526#M566299 Gysbert_Wassenaar 2012-11-28T14:53:36Z