topic Re: Set Analysis or Scripting? in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-or-Scripting/m-p/436510#M566428 <HTML><HEAD></HEAD><BODY><P>okay, i will try this one <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 17 Dec 2012 00:39:12 GMT 2012-12-17T00:39:12Z Set Analysis or Scripting? https://community.qlik.com/t5/QlikView/Set-Analysis-or-Scripting/m-p/436507#M566425 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>What approach is best for this problem?</P><P></P><P>I have a table</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="156" style="width: 526px; border: 1px solid rgb(0, 0, 0); height: 158px;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>ID</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>ID2</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Date</STRONG></SPAN></TH></TR><TR><TD>S-1</TD><TD>1</TD><TD>11/17/2012</TD></TR><TR><TD>S-2</TD><TD>1</TD><TD>12/12/2012</TD></TR><TR><TD>R-1</TD><TD>2</TD><TD>1/17/2012</TD></TR><TR><TD>R-1b</TD><TD>3</TD><TD>5/4/2012</TD></TR><TR><TD>R-1c</TD><TD>4</TD><TD>6/12/12</TD></TR></TBODY></TABLE><P></P><P>I need to get all the ID that have a count of 1 in ID2.</P><P>if(count(ID2)=1, ID)</P><P>So I need to get all the ID with only 1 count for ID2 and the specific date.</P><P>How can I achieve this?</P><P></P><P>Answer base on the table:</P><P>IDs.. </P><P>R-1 - 1/17/2012</P><P>R-1b - 5/4/2012</P><P>R-1c - 6/12/12</P><P></P><P>I need to show this in Pivot Table.</P><P></P><P></P><P>Thanks,</P><P>Donna</P></BODY></HTML> Fri, 14 Dec 2012 03:34:32 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-or-Scripting/m-p/436507#M566425 2012-12-14T03:34:32Z Re: Set Analysis or Scripting? https://community.qlik.com/t5/QlikView/Set-Analysis-or-Scripting/m-p/436508#M566426 <HTML><HEAD></HEAD><BODY><P>Just go with set analysis</P><P>use calculated dimension...only({$&lt;count(id2)=1&gt;}ID)..</P><P>in expression just give ...Date</P><P></P><P></P><P>hope this help you..</P></BODY></HTML> Fri, 14 Dec 2012 04:43:36 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-or-Scripting/m-p/436508#M566426 sujeetsingh 2012-12-14T04:43:36Z Re: Set Analysis or Scripting? https://community.qlik.com/t5/QlikView/Set-Analysis-or-Scripting/m-p/436509#M566427 <HTML><HEAD></HEAD><BODY><P>try with this expression :-</P><P>if(aggr(nodistinct count(ID2),ID2)=1,Date)</P><P></P><P>dimension :-</P><P>ID</P></BODY></HTML> Fri, 14 Dec 2012 06:48:16 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-or-Scripting/m-p/436509#M566427 2012-12-14T06:48:16Z Re: Set Analysis or Scripting? https://community.qlik.com/t5/QlikView/Set-Analysis-or-Scripting/m-p/436510#M566428 <HTML><HEAD></HEAD><BODY><P>okay, i will try this one <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 17 Dec 2012 00:39:12 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-or-Scripting/m-p/436510#M566428 2012-12-17T00:39:12Z