topic Re: How to write this set analysis? in QlikView https://community.qlik.com/t5/QlikView/How-to-write-this-set-analysis/m-p/411359#M153164 <HTML><HEAD></HEAD><BODY><P>Try something like this:</P><P></P><P>=count (distinct {$&lt;CustomerID = P ({1&lt;Code={"EN"}&gt;} CustomerID ) &gt;*&lt;CustomerID = P ({1&lt;Code={"GE"}&gt;} CustomerID ) &gt; } CustomerID )</P></BODY></HTML> Mon, 17 Sep 2012 09:54:51 GMT jvitantonio 2012-09-17T09:54:51Z How to write this set analysis? https://community.qlik.com/t5/QlikView/How-to-write-this-set-analysis/m-p/411358#M153163 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have the following table:</P><P></P><P>CustomerId Code</P><P>1, EN</P><P>1, GE</P><P>2, EN</P><P></P><P>I want to get how many Customers have both EN Code and GE code.</P><P></P><P>It is clear that just Customer 1. How to use count function to get it?</P><P></P><P></P><P>Many thanks.</P></BODY></HTML> Mon, 17 Sep 2012 09:47:16 GMT https://community.qlik.com/t5/QlikView/How-to-write-this-set-analysis/m-p/411358#M153163 2012-09-17T09:47:16Z Re: How to write this set analysis? https://community.qlik.com/t5/QlikView/How-to-write-this-set-analysis/m-p/411359#M153164 <HTML><HEAD></HEAD><BODY><P>Try something like this:</P><P></P><P>=count (distinct {$&lt;CustomerID = P ({1&lt;Code={"EN"}&gt;} CustomerID ) &gt;*&lt;CustomerID = P ({1&lt;Code={"GE"}&gt;} CustomerID ) &gt; } CustomerID )</P></BODY></HTML> Mon, 17 Sep 2012 09:54:51 GMT https://community.qlik.com/t5/QlikView/How-to-write-this-set-analysis/m-p/411359#M153164 jvitantonio 2012-09-17T09:54:51Z