topic Re: Count() of a count() column in App Development https://community.qlik.com/t5/App-Development/Count-of-a-count-column/m-p/1729671#M55637 <P>Fits perfect.! Thanks.!</P> Tue, 21 Jul 2020 19:18:56 GMT NelsonDiazDean01 2020-07-21T19:18:56Z Count() of a count() column https://community.qlik.com/t5/App-Development/Count-of-a-count-column/m-p/1729511#M55622 <P>Hello...</P><P>Have an issue with a set analysis.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="NelsonDiazDean01_0-1595338613321.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/37770i68BD2DA6C3EA0E00/image-size/medium?v=v2&amp;px=400" role="button" title="NelsonDiazDean01_0-1595338613321.png" alt="NelsonDiazDean01_0-1595338613321.png" /></span></P><P>What I need is the number of repetitions of 1's, 2's, etc...</P><P>Would be owesome if that could be in a table...</P><P>How many 1, how many 2, and so on...</P> Tue, 21 Jul 2020 13:39:38 GMT https://community.qlik.com/t5/App-Development/Count-of-a-count-column/m-p/1729511#M55622 NelsonDiazDean01 2020-07-21T13:39:38Z Re: Count() of a count() column https://community.qlik.com/t5/App-Development/Count-of-a-count-column/m-p/1729515#M55623 <P>Calculated dimension : <FONT face="courier new,courier">=Aggr(Count(IdDesc),&nbsp;IdDesc)</FONT></P><P>Exp : <FONT face="courier new,courier">=Count(Aggr(Count(IdDesc),&nbsp;IdDesc))</FONT></P><P>&nbsp;</P><P>Note : Change the dimension name.</P> Tue, 21 Jul 2020 13:55:44 GMT https://community.qlik.com/t5/App-Development/Count-of-a-count-column/m-p/1729515#M55623 tresB 2020-07-21T13:55:44Z Re: Count() of a count() column https://community.qlik.com/t5/App-Development/Count-of-a-count-column/m-p/1729516#M55624 <P>Hi</P><P>check once using AGGR</P><P>like</P><P>Aggr( count (fieldname), fieldname)</P> Tue, 21 Jul 2020 13:57:31 GMT https://community.qlik.com/t5/App-Development/Count-of-a-count-column/m-p/1729516#M55624 NitinK7 2020-07-21T13:57:31Z Re: Count() of a count() column https://community.qlik.com/t5/App-Development/Count-of-a-count-column/m-p/1729671#M55637 <P>Fits perfect.! Thanks.!</P> Tue, 21 Jul 2020 19:18:56 GMT https://community.qlik.com/t5/App-Development/Count-of-a-count-column/m-p/1729671#M55637 NelsonDiazDean01 2020-07-21T19:18:56Z