topic Count values from one column that are in another in App Development https://community.qlik.com/t5/App-Development/Count-values-from-one-column-that-are-in-another/m-p/1583554#M42660 <P>Hi,</P><P>Can somebody help me with something. I need to count how many distinct values from one column are in another. For example:</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Column A</TD><TD>Column B</TD></TR><TR><TD>A</TD><TD>A</TD></TR><TR><TD>D</TD><TD>B</TD></TR><TR><TD>C</TD><TD>C</TD></TR><TR><TD>A</TD><TD>D</TD></TR><TR><TD>Z</TD><TD>E</TD></TR><TR><TD>X</TD><TD>F</TD></TR><TR><TD>B</TD><TD>G</TD></TR><TR><TD>P</TD><TD>H</TD></TR><TR><TD>I</TD><TD>I</TD></TR><TR><TD>L</TD><TD>J</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>So, if I want to count distinct values from Column A that are present in Column B, the result would be 5.</P><P>Any ideas to do it? Script or graph formula?</P> Wed, 22 May 2019 19:11:45 GMT danielca 2019-05-22T19:11:45Z Count values from one column that are in another https://community.qlik.com/t5/App-Development/Count-values-from-one-column-that-are-in-another/m-p/1583554#M42660 <P>Hi,</P><P>Can somebody help me with something. I need to count how many distinct values from one column are in another. For example:</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Column A</TD><TD>Column B</TD></TR><TR><TD>A</TD><TD>A</TD></TR><TR><TD>D</TD><TD>B</TD></TR><TR><TD>C</TD><TD>C</TD></TR><TR><TD>A</TD><TD>D</TD></TR><TR><TD>Z</TD><TD>E</TD></TR><TR><TD>X</TD><TD>F</TD></TR><TR><TD>B</TD><TD>G</TD></TR><TR><TD>P</TD><TD>H</TD></TR><TR><TD>I</TD><TD>I</TD></TR><TR><TD>L</TD><TD>J</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>So, if I want to count distinct values from Column A that are present in Column B, the result would be 5.</P><P>Any ideas to do it? Script or graph formula?</P> Wed, 22 May 2019 19:11:45 GMT https://community.qlik.com/t5/App-Development/Count-values-from-one-column-that-are-in-another/m-p/1583554#M42660 danielca 2019-05-22T19:11:45Z Re: Count values from one column that are in another https://community.qlik.com/t5/App-Development/Count-values-from-one-column-that-are-in-another/m-p/1583560#M42661 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 975px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/12513iD093BF653C14C4E6/image-size/large?v=v2&amp;px=999" role="button" title="image.png" alt="image.png" /></span></P><P>You could use this or a variant of this expression below.&nbsp;</P><LI-CODE lang="markup">FindOneOf([Column A], concat(total [Column B]))</LI-CODE><P>&nbsp;</P><P>I use two variants, one with aggr in the attached qvf.</P> Wed, 22 May 2019 19:26:21 GMT https://community.qlik.com/t5/App-Development/Count-values-from-one-column-that-are-in-another/m-p/1583560#M42661 Vegar 2019-05-22T19:26:21Z