https://community.qlik.com/t5/QlikView/Qlikview-Expression/m-p/1811337#M1212651 <P>Hi,</P><P>I have a number of Customers where the orders are at a specific phase, see below example, I only want to count those customer where all orders are at phase 11, Customer A has some but not all, Customer C is the only Customer where all orders are at phase 11.</P><P>I want to display the result in a Text Object</P><TABLE><TBODY><TR><TD>Customer</TD><TD>Order ID</TD><TD>Phase</TD></TR><TR><TD>A</TD><TD>1</TD><TD>10</TD></TR><TR><TD>A</TD><TD>2</TD><TD>11</TD></TR><TR><TD>A</TD><TD>3</TD><TD>11</TD></TR><TR><TD>A</TD><TD>4</TD><TD>12</TD></TR><TR><TD>B</TD><TD>5</TD><TD>2</TD></TR><TR><TD>B</TD><TD>6</TD><TD>1</TD></TR><TR><TD>B</TD><TD>7</TD><TD>1</TD></TR><TR><TD>B</TD><TD>8</TD><TD>1</TD></TR><TR><TD>C</TD><TD>9</TD><TD>11</TD></TR><TR><TD>C</TD><TD>10</TD><TD>11</TD></TR><TR><TD>C</TD><TD>11</TD><TD>11</TD></TR><TR><TD>C</TD><TD>12</TD><TD>11</TD></TR></TBODY></TABLE> Fri, 28 May 2021 11:43:59 GMT principal 2021-05-28T11:43:59Z https://community.qlik.com/t5/QlikView/Qlikview-Expression/m-p/1811337#M1212651 <P>Hi,</P><P>I have a number of Customers where the orders are at a specific phase, see below example, I only want to count those customer where all orders are at phase 11, Customer A has some but not all, Customer C is the only Customer where all orders are at phase 11.</P><P>I want to display the result in a Text Object</P><TABLE><TBODY><TR><TD>Customer</TD><TD>Order ID</TD><TD>Phase</TD></TR><TR><TD>A</TD><TD>1</TD><TD>10</TD></TR><TR><TD>A</TD><TD>2</TD><TD>11</TD></TR><TR><TD>A</TD><TD>3</TD><TD>11</TD></TR><TR><TD>A</TD><TD>4</TD><TD>12</TD></TR><TR><TD>B</TD><TD>5</TD><TD>2</TD></TR><TR><TD>B</TD><TD>6</TD><TD>1</TD></TR><TR><TD>B</TD><TD>7</TD><TD>1</TD></TR><TR><TD>B</TD><TD>8</TD><TD>1</TD></TR><TR><TD>C</TD><TD>9</TD><TD>11</TD></TR><TR><TD>C</TD><TD>10</TD><TD>11</TD></TR><TR><TD>C</TD><TD>11</TD><TD>11</TD></TR><TR><TD>C</TD><TD>12</TD><TD>11</TD></TR></TBODY></TABLE> Fri, 28 May 2021 11:43:59 GMT https://community.qlik.com/t5/QlikView/Qlikview-Expression/m-p/1811337#M1212651 principal 2021-05-28T11:43:59Z https://community.qlik.com/t5/QlikView/Qlikview-Expression/m-p/1811408#M1212662 <P>=Count({&lt;Customer=E({&lt;Phase-={'11'}&gt;}Customer)&gt;}Distinct Customer)</P><P>&nbsp;</P> Fri, 28 May 2021 14:31:58 GMT https://community.qlik.com/t5/QlikView/Qlikview-Expression/m-p/1811408#M1212662 jwjackso 2021-05-28T14:31:58Z https://community.qlik.com/t5/QlikView/Qlikview-Expression/m-p/1825751#M1213944 <P>That did return the correct result, can anyone else help?</P> Fri, 30 Jul 2021 11:54:00 GMT https://community.qlik.com/t5/QlikView/Qlikview-Expression/m-p/1825751#M1213944 principal 2021-07-30T11:54:00Z