topic Problems when using Distinct/Data Joins in QlikView https://community.qlik.com/t5/QlikView/Problems-when-using-Distinct-Data-Joins/m-p/312320#M115325 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>For some reason, after my data has been loaded and joined (outer joins and left joins) my sums and counts require the DISTINCT qualifier, as the value is 3 times bigger than it should be... But I don't think I can use the distinct qualifier on my sum calculations, as the value that returns is smaller than it should be (getting rid of genuine duplicates). What can I do?</P><P></P><P>Kind Regards,</P><P>Dayna</P></BODY></HTML> Thu, 23 Feb 2012 10:24:16 GMT Dayna 2012-02-23T10:24:16Z Problems when using Distinct/Data Joins https://community.qlik.com/t5/QlikView/Problems-when-using-Distinct-Data-Joins/m-p/312320#M115325 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>For some reason, after my data has been loaded and joined (outer joins and left joins) my sums and counts require the DISTINCT qualifier, as the value is 3 times bigger than it should be... But I don't think I can use the distinct qualifier on my sum calculations, as the value that returns is smaller than it should be (getting rid of genuine duplicates). What can I do?</P><P></P><P>Kind Regards,</P><P>Dayna</P></BODY></HTML> Thu, 23 Feb 2012 10:24:16 GMT https://community.qlik.com/t5/QlikView/Problems-when-using-Distinct-Data-Joins/m-p/312320#M115325 Dayna 2012-02-23T10:24:16Z Problems when using Distinct/Data Joins https://community.qlik.com/t5/QlikView/Problems-when-using-Distinct-Data-Joins/m-p/312321#M115326 <HTML><HEAD></HEAD><BODY><P>Hi, this is thecorrect behavior in qlik. Can you please upload your app so I can tell you how to you the distinc function using ur example?</P></BODY></HTML> Thu, 23 Feb 2012 10:42:51 GMT https://community.qlik.com/t5/QlikView/Problems-when-using-Distinct-Data-Joins/m-p/312321#M115326 jvitantonio 2012-02-23T10:42:51Z Problems when using Distinct/Data Joins https://community.qlik.com/t5/QlikView/Problems-when-using-Distinct-Data-Joins/m-p/312322#M115327 <HTML><HEAD></HEAD><BODY><P>Hi Dayna,</P><P>I agree with Armin. </P><P>It looks like you loaded some data twice. Or the joins (joinfields) to merge your QV-tables do not fit (any more).</P><P></P><P>Btw: Using an outer join between table T1 and T2 is to combine every row of T1 with every row of T2. I need this very seldom, do you really want that?</P><P></P><P>HtH</P><P>Roland</P></BODY></HTML> Thu, 23 Feb 2012 11:09:49 GMT https://community.qlik.com/t5/QlikView/Problems-when-using-Distinct-Data-Joins/m-p/312322#M115327 2012-02-23T11:09:49Z Problems when using Distinct/Data Joins https://community.qlik.com/t5/QlikView/Problems-when-using-Distinct-Data-Joins/m-p/312323#M115328 <HTML><HEAD></HEAD><BODY><P> Hello Both,</P><P></P><P>I found half the cause to my distinct problem, the table I was joining to was a conversion table, so it provided multiple rows for each record... This I've resolved.. Just checking the rest, but I think it might be the joins.</P><P></P><P>Many thanks,</P><P>Dayna</P></BODY></HTML> Thu, 23 Feb 2012 11:13:43 GMT https://community.qlik.com/t5/QlikView/Problems-when-using-Distinct-Data-Joins/m-p/312323#M115328 Dayna 2012-02-23T11:13:43Z