topic count common value in QlikView https://community.qlik.com/t5/QlikView/count-common-value/m-p/140165#M20883 <HTML><HEAD></HEAD><BODY><P>hi</P><P></P><P>i have a table that have 2 field, project and vendor</P><P>i need to create pie that show how many vendor work on just one project and how many vendors work s on more than one projects</P><P>can any one help me for this two expression</P><P></P><P>the table like below</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Vendor</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Project</STRONG></TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">2</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">3</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">4</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">5</TD></TR><TR><TD style="padding: 2px;">D</TD><TD style="padding: 2px;">6</TD></TR><TR><TD style="padding: 2px;">E</TD><TD style="padding: 2px;">7</TD></TR></TBODY></TABLE><P>in this sample i need the pie chart that show first slice with value 2 and second slice with 3</P></BODY></HTML> Sun, 07 Oct 2018 06:12:18 GMT omid5ive 2018-10-07T06:12:18Z count common value https://community.qlik.com/t5/QlikView/count-common-value/m-p/140165#M20883 <HTML><HEAD></HEAD><BODY><P>hi</P><P></P><P>i have a table that have 2 field, project and vendor</P><P>i need to create pie that show how many vendor work on just one project and how many vendors work s on more than one projects</P><P>can any one help me for this two expression</P><P></P><P>the table like below</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Vendor</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Project</STRONG></TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">2</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">3</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">4</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">5</TD></TR><TR><TD style="padding: 2px;">D</TD><TD style="padding: 2px;">6</TD></TR><TR><TD style="padding: 2px;">E</TD><TD style="padding: 2px;">7</TD></TR></TBODY></TABLE><P>in this sample i need the pie chart that show first slice with value 2 and second slice with 3</P></BODY></HTML> Sun, 07 Oct 2018 06:12:18 GMT https://community.qlik.com/t5/QlikView/count-common-value/m-p/140165#M20883 omid5ive 2018-10-07T06:12:18Z Re: count common value https://community.qlik.com/t5/QlikView/count-common-value/m-p/140166#M20884 <HTML><HEAD></HEAD><BODY><P>i think i can find it</P><P>=count( DISTINCT if(Aggr(Count(distinct ProjectName),vendor_name)&gt;1 ,vendor_name,Null())) for more than one</P><P></P><P><SPAN style="font-size: 13.3333px;">=count( DISTINCT if(Aggr(Count(distinct ProjectName),vendor_name)=1 ,vendor_name,Null())) for just one</SPAN></P></BODY></HTML> Sun, 07 Oct 2018 06:42:34 GMT https://community.qlik.com/t5/QlikView/count-common-value/m-p/140166#M20884 omid5ive 2018-10-07T06:42:34Z