topic Re: CountIf issues in QlikView https://community.qlik.com/t5/QlikView/CountIf-issues/m-p/1231226#M863450 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny</P></BODY></HTML> Fri, 23 Dec 2016 19:51:02 GMT 2016-12-23T19:51:02Z CountIf issues https://community.qlik.com/t5/QlikView/CountIf-issues/m-p/1231223#M863447 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a data set similar to:</P><P></P><P><SPAN style="text-decoration: underline;"><STRONG>CourseNumber</STRONG></SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="text-decoration: underline;"><STRONG>City</STRONG></SPAN></P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; New York</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Miami</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Miami</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; San Francisco</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">San Francisco</SPAN></P><P>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Chicago</P><P>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Orlando</P><P>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; New Jersey</P><P>4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Orlando</P><P>5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Boston</P><P>6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Boston&nbsp;&nbsp;&nbsp;&nbsp; </P><P></P><P>And I am trying to count how many courses have a count of distinct cities higher than 2. I think I have to use aggr, but I am a but lost, any suggestions?</P><P></P><P>Thanks</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/CountIf-issues/m-p/1231223#M863447 2020-11-25T16:16:04Z Re: CountIf issues https://community.qlik.com/t5/QlikView/CountIf-issues/m-p/1231224#M863448 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>Count(DISTINCT {&lt;CourseNumber = {"=Count(DISTINCT City) &gt; 2"}&gt;} CourseNumber)</STRONG></P><P></P><P><SPAN style="text-decoration: line-through;">or</SPAN></P><P></P><P><SPAN style="font-size: 13.3333px;"><STRONG style="text-decoration: line-through;">Count(DISTINCT {&lt;CourseNumber = {"=Count(City) &gt; 2"}&gt;} CourseNumber)</STRONG></SPAN></P><P></P><P>So based on the sample, you would see a count of 1 which would be CourseNumber 3</P></BODY></HTML> Fri, 23 Dec 2016 18:12:31 GMT https://community.qlik.com/t5/QlikView/CountIf-issues/m-p/1231224#M863448 sunny_talwar 2016-12-23T18:12:31Z Re: CountIf issues https://community.qlik.com/t5/QlikView/CountIf-issues/m-p/1231225#M863449 <HTML><HEAD></HEAD><BODY><P>I think, this might help you..</P><P></P><P>=Count({&lt;CourseNumber={'&gt;2'}&gt;}DISTINCT City)</P></BODY></HTML> Fri, 23 Dec 2016 18:24:36 GMT https://community.qlik.com/t5/QlikView/CountIf-issues/m-p/1231225#M863449 qlik_jaijhn 2016-12-23T18:24:36Z Re: CountIf issues https://community.qlik.com/t5/QlikView/CountIf-issues/m-p/1231226#M863450 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny</P></BODY></HTML> Fri, 23 Dec 2016 19:51:02 GMT https://community.qlik.com/t5/QlikView/CountIf-issues/m-p/1231226#M863450 2016-12-23T19:51:02Z Re: CountIf issues https://community.qlik.com/t5/QlikView/CountIf-issues/m-p/1231227#M863451 <HTML><HEAD></HEAD><BODY><P>It seems that counting from the perspective of the course number, gives me a higher count when I run the formula against my full data set. But thanks anyways John.</P></BODY></HTML> Fri, 23 Dec 2016 19:52:38 GMT https://community.qlik.com/t5/QlikView/CountIf-issues/m-p/1231227#M863451 2016-12-23T19:52:38Z