topic Re: count held in common value in QlikView https://community.qlik.com/t5/QlikView/count-held-in-common-value/m-p/74863#M12377 <HTML><HEAD></HEAD><BODY><P>try this in your textbox</P><P></P><P>=Count({&lt;vendor={"=count(project)&gt;=2"}&gt;}distinct vendor)</P></BODY></HTML> Sat, 21 Apr 2018 13:25:38 GMT shiveshsingh 2018-04-21T13:25:38Z count held in common value https://community.qlik.com/t5/QlikView/count-held-in-common-value/m-p/74862#M12376 <HTML><HEAD></HEAD><BODY><P>hi</P><P>i have a table like below</P><P></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;">B</TD><TD style="padding: 2px;">2</TD></TR><TR><TD style="padding: 2px;">A</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></TBODY></TABLE><P>i want to know that ho many of my vendor work on more than one project; in this case in text box i need to see 2 because A and B work on more than one project</P><P>what should i do?</P></BODY></HTML> Sat, 21 Apr 2018 12:01:18 GMT https://community.qlik.com/t5/QlikView/count-held-in-common-value/m-p/74862#M12376 omid5ive 2018-04-21T12:01:18Z Re: count held in common value https://community.qlik.com/t5/QlikView/count-held-in-common-value/m-p/74863#M12377 <HTML><HEAD></HEAD><BODY><P>try this in your textbox</P><P></P><P>=Count({&lt;vendor={"=count(project)&gt;=2"}&gt;}distinct vendor)</P></BODY></HTML> Sat, 21 Apr 2018 13:25:38 GMT https://community.qlik.com/t5/QlikView/count-held-in-common-value/m-p/74863#M12377 shiveshsingh 2018-04-21T13:25:38Z