topic Re: Comparation in QlikView https://community.qlik.com/t5/QlikView/Comparation/m-p/39897#M6718 <HTML><HEAD></HEAD><BODY><P>says 5 and not 2 as it is the correct result, thank you very much, you are very close</P></BODY></HTML> Fri, 16 Feb 2018 14:22:36 GMT Anonymous 2018-02-16T14:22:36Z Comparation https://community.qlik.com/t5/QlikView/Comparation/m-p/39895#M6716 <HTML><HEAD></HEAD><BODY><P>have</P><P></P><P>colum1 colum2</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3</P><P>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4</P><P>4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6</P><P>5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8</P><P></P><P></P><P>I need to count what records in column 1 are in column 2</P><P></P><P>thnxs</P></BODY></HTML> Fri, 16 Feb 2018 14:05:27 GMT https://community.qlik.com/t5/QlikView/Comparation/m-p/39895#M6716 Anonymous 2018-02-16T14:05:27Z Re: Comparation https://community.qlik.com/t5/QlikView/Comparation/m-p/39896#M6717 <HTML><HEAD></HEAD><BODY><P>Like this?</P><P></P><P>=Count({&lt;colum2=P(colum1)&gt;} colum1)</P></BODY></HTML> Fri, 16 Feb 2018 14:16:47 GMT https://community.qlik.com/t5/QlikView/Comparation/m-p/39896#M6717 stigchel 2018-02-16T14:16:47Z Re: Comparation https://community.qlik.com/t5/QlikView/Comparation/m-p/39897#M6718 <HTML><HEAD></HEAD><BODY><P>says 5 and not 2 as it is the correct result, thank you very much, you are very close</P></BODY></HTML> Fri, 16 Feb 2018 14:22:36 GMT https://community.qlik.com/t5/QlikView/Comparation/m-p/39897#M6718 Anonymous 2018-02-16T14:22:36Z Re: Comparation https://community.qlik.com/t5/QlikView/Comparation/m-p/39898#M6719 <HTML><HEAD></HEAD><BODY><P>For me it says 3 because 2,3,4 of colum1 are also in colum2, see attached</P><P></P><P>What is the logic for 2 being the correct result?</P></BODY></HTML> Fri, 16 Feb 2018 14:28:45 GMT https://community.qlik.com/t5/QlikView/Comparation/m-p/39898#M6719 stigchel 2018-02-16T14:28:45Z Re: Comparation https://community.qlik.com/t5/QlikView/Comparation/m-p/39899#M6720 <HTML><HEAD></HEAD><BODY><P>Thank you very much, have an excellent day</P></BODY></HTML> Fri, 16 Feb 2018 14:32:11 GMT https://community.qlik.com/t5/QlikView/Comparation/m-p/39899#M6720 Anonymous 2018-02-16T14:32:11Z Re: Comparation https://community.qlik.com/t5/QlikView/Comparation/m-p/39900#M6721 <HTML><HEAD></HEAD><BODY><P>how would COUNT DISTINCT?</P></BODY></HTML> Fri, 16 Feb 2018 14:58:45 GMT https://community.qlik.com/t5/QlikView/Comparation/m-p/39900#M6721 Anonymous 2018-02-16T14:58:45Z