topic Counting a Count in QlikView https://community.qlik.com/t5/QlikView/Counting-a-Count/m-p/1162855#M898960 <HTML><HEAD></HEAD><BODY><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>Person</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Visit</STRONG></TH></TR><TR><TD style="padding: 2px;">Emily</TD><TD style="padding: 2px;"><P>1/1/16</P></TD></TR><TR><TD style="padding: 2px;">Emily</TD><TD style="padding: 2px;">2/1/16</TD></TR><TR><TD style="padding: 2px;">Sal</TD><TD style="padding: 2px;">1/15/16</TD></TR><TR><TD style="padding: 2px;">Sue</TD><TD style="padding: 2px;">2/15/16</TD></TR><TR><TD style="padding: 2px;">Sue</TD><TD style="padding: 2px;">2/16/16</TD></TR></TBODY></TABLE><P>I want to be able to count the number of People if the visit count per person is greater than 1.&nbsp; So in the above table, my answer would be 2.&nbsp; I would count Emily and Sue, but not Sal.&nbsp;&nbsp;&nbsp; </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Counting a Count https://community.qlik.com/t5/QlikView/Counting-a-Count/m-p/1162855#M898960 <HTML><HEAD></HEAD><BODY><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>Person</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Visit</STRONG></TH></TR><TR><TD style="padding: 2px;">Emily</TD><TD style="padding: 2px;"><P>1/1/16</P></TD></TR><TR><TD style="padding: 2px;">Emily</TD><TD style="padding: 2px;">2/1/16</TD></TR><TR><TD style="padding: 2px;">Sal</TD><TD style="padding: 2px;">1/15/16</TD></TR><TR><TD style="padding: 2px;">Sue</TD><TD style="padding: 2px;">2/15/16</TD></TR><TR><TD style="padding: 2px;">Sue</TD><TD style="padding: 2px;">2/16/16</TD></TR></TBODY></TABLE><P>I want to be able to count the number of People if the visit count per person is greater than 1.&nbsp; So in the above table, my answer would be 2.&nbsp; I would count Emily and Sue, but not Sal.&nbsp;&nbsp;&nbsp; </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Counting-a-Count/m-p/1162855#M898960 2020-11-25T16:16:04Z Re: Counting a Count https://community.qlik.com/t5/QlikView/Counting-a-Count/m-p/1162856#M898961 <HTML><HEAD></HEAD><BODY><P>Try as expression e.g. in a text box</P><P></P><P>=Count({&lt;Person = {"=Count(Visit)&gt;1"}&gt;} DISTINCT Person)</P></BODY></HTML> Wed, 27 Jul 2016 22:09:24 GMT https://community.qlik.com/t5/QlikView/Counting-a-Count/m-p/1162856#M898961 swuehl 2016-07-27T22:09:24Z Re: Counting a Count https://community.qlik.com/t5/QlikView/Counting-a-Count/m-p/1162857#M898962 <HTML><HEAD></HEAD><BODY><P>Thank you, that worked perfectly!</P></BODY></HTML> Wed, 27 Jul 2016 22:13:08 GMT https://community.qlik.com/t5/QlikView/Counting-a-Count/m-p/1162857#M898962 2016-07-27T22:13:08Z