topic Count inside set analysis in App Development https://community.qlik.com/t5/App-Development/Count-inside-set-analysis/m-p/105292#M7142 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm trying to use the following metric, but i think that using an if is not producing the correct results. Is there a way to include a count inside the set analysis?</P><P></P><P>This is the original metric:</P><P></P><P>if(count(X)&gt;5,sum({&lt;indicador_valor-={99}&gt;}indicador_valor*fe)/sum({&lt;indicador_valor-={99}&gt;} fe))</P><P></P><P>Thanks.</P></BODY></HTML> Wed, 22 Dec 2021 15:42:54 GMT Anonymous 2021-12-22T15:42:54Z Count inside set analysis https://community.qlik.com/t5/App-Development/Count-inside-set-analysis/m-p/105292#M7142 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm trying to use the following metric, but i think that using an if is not producing the correct results. Is there a way to include a count inside the set analysis?</P><P></P><P>This is the original metric:</P><P></P><P>if(count(X)&gt;5,sum({&lt;indicador_valor-={99}&gt;}indicador_valor*fe)/sum({&lt;indicador_valor-={99}&gt;} fe))</P><P></P><P>Thanks.</P></BODY></HTML> Wed, 22 Dec 2021 15:42:54 GMT https://community.qlik.com/t5/App-Development/Count-inside-set-analysis/m-p/105292#M7142 Anonymous 2021-12-22T15:42:54Z