topic Problem counting headers in QlikView https://community.qlik.com/t5/QlikView/Problem-counting-headers/m-p/671077#M674432 <HTML><HEAD></HEAD><BODY><P>I have two tables: Claim Headers, and Referrals, Referrals has a many-to-one releationship with the Headers, keys are DealerID and Claim Number.</P><P></P><P>I need to calculate Total No. of Referrals / Total No. Claims.</P><P></P><P>The problem with the script below is that if a claim has more than one rferral, the header gets counted more than once - I could make a second pass of the table and count distinct claim numbers, but is there a better way?</P><P></P><P>ClaimStats2T:<BR />LOAD<BR />DealerID, // key<BR />[Claim Number], // key<BR />KPIYear,<BR />KPIMonth,<BR />CountClaims // is always 1, used to sum<BR />Resident ClaimFacts<BR />;<BR />Left Join<BR />LOAD<BR />DealerID, // key<BR />[Claim Number], //key<BR />ReferredDate,<BR />1 as ClaimReferred<BR />;<BR />SQL </P><P>... </P><P></P><P>Regards,</P><P>Marty.</P></BODY></HTML> Wed, 13 Aug 2014 09:10:27 GMT martynlloyd 2014-08-13T09:10:27Z Problem counting headers https://community.qlik.com/t5/QlikView/Problem-counting-headers/m-p/671077#M674432 <HTML><HEAD></HEAD><BODY><P>I have two tables: Claim Headers, and Referrals, Referrals has a many-to-one releationship with the Headers, keys are DealerID and Claim Number.</P><P></P><P>I need to calculate Total No. of Referrals / Total No. Claims.</P><P></P><P>The problem with the script below is that if a claim has more than one rferral, the header gets counted more than once - I could make a second pass of the table and count distinct claim numbers, but is there a better way?</P><P></P><P>ClaimStats2T:<BR />LOAD<BR />DealerID, // key<BR />[Claim Number], // key<BR />KPIYear,<BR />KPIMonth,<BR />CountClaims // is always 1, used to sum<BR />Resident ClaimFacts<BR />;<BR />Left Join<BR />LOAD<BR />DealerID, // key<BR />[Claim Number], //key<BR />ReferredDate,<BR />1 as ClaimReferred<BR />;<BR />SQL </P><P>... </P><P></P><P>Regards,</P><P>Marty.</P></BODY></HTML> Wed, 13 Aug 2014 09:10:27 GMT https://community.qlik.com/t5/QlikView/Problem-counting-headers/m-p/671077#M674432 martynlloyd 2014-08-13T09:10:27Z Re: Problem counting headers https://community.qlik.com/t5/QlikView/Problem-counting-headers/m-p/671078#M674435 <HTML><HEAD></HEAD><BODY><P>Would not&nbsp;&nbsp; =Count(<STRONG>Distinct </STRONG>..&nbsp; be an option? </P></BODY></HTML> Wed, 13 Aug 2014 09:14:14 GMT https://community.qlik.com/t5/QlikView/Problem-counting-headers/m-p/671078#M674435 tresB 2014-08-13T09:14:14Z