topic Set analysis problem in QlikView https://community.qlik.com/t5/QlikView/Set-analysis-problem/m-p/332361#M492380 <HTML><HEAD></HEAD><BODY><P>Hi,&nbsp; I'm struggling with a bit of set analysis. From the sample data below I'm trying to do a count of calls into response groups where they are missed. So id 1 went to 3 different users but was answered by one person so my expression would return 0. Id 2 went to 4 different users and was not answered by anyone and therefore would return 1.</P><P></P><P>ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; call_response</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Answered</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Missed</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Missed</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Missed</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Missed</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Missed</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Missed</P><P></P><P>Help please!</P><P></P><P>Thanks</P><P>Neil</P></BODY></HTML> Tue, 03 Jul 2012 18:50:14 GMT 2012-07-03T18:50:14Z Set analysis problem https://community.qlik.com/t5/QlikView/Set-analysis-problem/m-p/332361#M492380 <HTML><HEAD></HEAD><BODY><P>Hi,&nbsp; I'm struggling with a bit of set analysis. From the sample data below I'm trying to do a count of calls into response groups where they are missed. So id 1 went to 3 different users but was answered by one person so my expression would return 0. Id 2 went to 4 different users and was not answered by anyone and therefore would return 1.</P><P></P><P>ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; call_response</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Answered</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Missed</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Missed</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Missed</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Missed</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Missed</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Missed</P><P></P><P>Help please!</P><P></P><P>Thanks</P><P>Neil</P></BODY></HTML> Tue, 03 Jul 2012 18:50:14 GMT https://community.qlik.com/t5/QlikView/Set-analysis-problem/m-p/332361#M492380 2012-07-03T18:50:14Z Re: Set analysis problem https://community.qlik.com/t5/QlikView/Set-analysis-problem/m-p/332362#M492381 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; Try this,</P><P></P><P></P><P></P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =If(Aggr(Count({&lt;call_response = {'Answered'}&gt;}call_response),ID) &gt; 0 ,0 ,1) <P></P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; Hope it helps</P></BODY></HTML> Tue, 03 Jul 2012 19:28:07 GMT https://community.qlik.com/t5/QlikView/Set-analysis-problem/m-p/332362#M492381 MayilVahanan 2012-07-03T19:28:07Z