https://community.qlik.com/t5/App-Development/Chart-Expression/m-p/1719720#M54699 <P>With data:</P><P>Data:<BR />Load * Inline [<BR />Values<BR />1<BR />1<BR />1<BR />3<BR />3<BR />3<BR />3<BR />4<BR />5<BR />];</P><P>&nbsp;</P><P>The expression,&nbsp;Sum(If(Aggr(count(Values),Values) &gt; 2,1,0)) returns 2.</P> Wed, 17 Jun 2020 15:38:52 GMT jwjackso 2020-06-17T15:38:52Z https://community.qlik.com/t5/App-Development/Chart-Expression/m-p/1719717#M54698 <P>Hi All,<BR />Is there any chart expression to calculate how many register are repeated more than twice?. For instance:</P><TABLE border="0" width="80" cellspacing="0" cellpadding="0"><TBODY><TR><TD width="80" height="20">Values</TD></TR><TR><TD height="20">1</TD></TR><TR><TD height="20">1</TD></TR><TR><TD height="20">1</TD></TR><TR><TD height="20">3</TD></TR><TR><TD height="20">3</TD></TR><TR><TD height="20">3</TD></TR><TR><TD height="20">3</TD></TR><TR><TD height="20">4</TD></TR><TR><TD height="20">5</TD></TR></TBODY></TABLE><P>The solution must be 2, the number 1 and number 3 are repeated more than twice.</P><P>Best regards,</P><P>Juan Muñoz.</P> Mon, 20 Dec 2021 21:08:46 GMT https://community.qlik.com/t5/App-Development/Chart-Expression/m-p/1719717#M54698 JuanMu 2021-12-20T21:08:46Z https://community.qlik.com/t5/App-Development/Chart-Expression/m-p/1719720#M54699 <P>With data:</P><P>Data:<BR />Load * Inline [<BR />Values<BR />1<BR />1<BR />1<BR />3<BR />3<BR />3<BR />3<BR />4<BR />5<BR />];</P><P>&nbsp;</P><P>The expression,&nbsp;Sum(If(Aggr(count(Values),Values) &gt; 2,1,0)) returns 2.</P> Wed, 17 Jun 2020 15:38:52 GMT https://community.qlik.com/t5/App-Development/Chart-Expression/m-p/1719720#M54699 jwjackso 2020-06-17T15:38:52Z https://community.qlik.com/t5/App-Development/Chart-Expression/m-p/1719934#M54738 <P>Great!!!!!</P><P>Thanks a lot!!!!</P> Thu, 18 Jun 2020 09:58:48 GMT https://community.qlik.com/t5/App-Development/Chart-Expression/m-p/1719934#M54738 JuanMu 2020-06-18T09:58:48Z