topic (Help! I need somebody HELP!) Count expression doesn't read accurate when using Set Analysis in QlikView https://community.qlik.com/t5/QlikView/Help-I-need-somebody-HELP-Count-expression-doesn-t-read-accurate/m-p/196373#M56481 <HTML><HEAD></HEAD><BODY><P>I'm trying to count distinct Account_Id's visited by each salesperson.</P><P>To do that accuratelly the Count statement should only evaluate the set where the total calls by salesperson are greater than 0, which is not doing and I can't figure why.</P><P>Take an example on the qvw attached:</P><P>The Contact Owner (CO) "Beatriz Aquino" Visited Entities should read 112 instead of 146 and Targeted Entities should read 129 instead of 150.</P><P>As far as I understand the problem is in the set analysis statement which is selecting distinct accounts where the CO have either a call or a target even if that call was made by another CO.</P><P>Looking forward for your help</P><P>Thanks</P></BODY></HTML> Thu, 24 Dec 2009 09:50:04 GMT 2009-12-24T09:50:04Z (Help! I need somebody HELP!) Count expression doesn't read accurate when using Set Analysis https://community.qlik.com/t5/QlikView/Help-I-need-somebody-HELP-Count-expression-doesn-t-read-accurate/m-p/196373#M56481 <HTML><HEAD></HEAD><BODY><P>I'm trying to count distinct Account_Id's visited by each salesperson.</P><P>To do that accuratelly the Count statement should only evaluate the set where the total calls by salesperson are greater than 0, which is not doing and I can't figure why.</P><P>Take an example on the qvw attached:</P><P>The Contact Owner (CO) "Beatriz Aquino" Visited Entities should read 112 instead of 146 and Targeted Entities should read 129 instead of 150.</P><P>As far as I understand the problem is in the set analysis statement which is selecting distinct accounts where the CO have either a call or a target even if that call was made by another CO.</P><P>Looking forward for your help</P><P>Thanks</P></BODY></HTML> Thu, 24 Dec 2009 09:50:04 GMT https://community.qlik.com/t5/QlikView/Help-I-need-somebody-HELP-Count-expression-doesn-t-read-accurate/m-p/196373#M56481 2009-12-24T09:50:04Z (Help! I need somebody HELP!) Count expression doesn't read accurate when using Set Analysis https://community.qlik.com/t5/QlikView/Help-I-need-somebody-HELP-Count-expression-doesn-t-read-accurate/m-p/196374#M56482 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I think I made it...</P><P>Please see the file attached. I just modified the set analysis formula.</P><P>Steve</P></BODY></HTML> Tue, 05 Jan 2010 23:42:15 GMT https://community.qlik.com/t5/QlikView/Help-I-need-somebody-HELP-Count-expression-doesn-t-read-accurate/m-p/196374#M56482 2010-01-05T23:42:15Z