https://community.qlik.com/t5/App-Development/Chart-Expression-II/m-p/1719996#M54744 <P>Try this:</P><P><FONT face="courier new,courier">Count(Distinct {&lt;Teléfonos={"=Count(Distinct Segmento)&gt;1"}&gt;}Teléfonos)</FONT></P> Thu, 18 Jun 2020 12:25:31 GMT tresB 2020-06-18T12:25:31Z https://community.qlik.com/t5/App-Development/Chart-Expression-II/m-p/1719994#M54743 <P>Hi All,<BR />Is there any chart expression to calculate how many "Teléfonos" have more than one "Segmento" distinct?. For instance:</P><TABLE border="0" width="160" cellspacing="0" cellpadding="0"><TBODY><TR><TD width="80" height="20">Teléfonos</TD><TD width="80">Segmento</TD></TR><TR><TD height="20">11111</TD><TD>RES</TD></TR><TR><TD height="20">11111</TD><TD>PYM</TD></TR><TR><TD height="20">22222</TD><TD>RES</TD></TR><TR><TD height="20">22222</TD><TD>PRO</TD></TR><TR><TD height="20">22222</TD><TD>PYM</TD></TR><TR><TD height="20">33333</TD><TD>RES</TD></TR><TR><TD height="20">44444</TD><TD>PYM</TD></TR><TR><TD height="20">55555</TD><TD>PRO</TD></TR><TR><TD height="20">66666</TD><TD>RES</TD></TR><TR><TD height="20">66666</TD><TD>RES</TD></TR></TBODY></TABLE><P>The solution must be 2, "Teléfono" number 11111 and 22222 have more than one "Segmento" distinct.</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-II/m-p/1719994#M54743 JuanMu 2021-12-20T21:08:46Z https://community.qlik.com/t5/App-Development/Chart-Expression-II/m-p/1719996#M54744 <P>Try this:</P><P><FONT face="courier new,courier">Count(Distinct {&lt;Teléfonos={"=Count(Distinct Segmento)&gt;1"}&gt;}Teléfonos)</FONT></P> Thu, 18 Jun 2020 12:25:31 GMT https://community.qlik.com/t5/App-Development/Chart-Expression-II/m-p/1719996#M54744 tresB 2020-06-18T12:25:31Z