https://community.qlik.com/t5/QlikView/Why-is-the-output-value-0/m-p/1996430#M1225686 <P>=Aggr(if([Average] &lt;= [Spec (Upper limit)] and [Average] &gt;= [Spec (Lower limit)],1,0),Id))&nbsp;</P> <P>and This&nbsp;</P> <P>=Sum(Aggr(if([Average] &lt;= [Spec (Upper limit)]&nbsp;and [Average] &gt;= [Spec (Lower limit)],1,0),Id))</P> <P>Same this return is 0.&nbsp;</P> <P>Why is the resulting value not sum the value 1 return the loop if ?</P> Fri, 15 Nov 2024 21:58:20 GMT Sxbbb 2024-11-15T21:58:20Z https://community.qlik.com/t5/QlikView/Why-is-the-output-value-0/m-p/1996430#M1225686 <P>=Aggr(if([Average] &lt;= [Spec (Upper limit)] and [Average] &gt;= [Spec (Lower limit)],1,0),Id))&nbsp;</P> <P>and This&nbsp;</P> <P>=Sum(Aggr(if([Average] &lt;= [Spec (Upper limit)]&nbsp;and [Average] &gt;= [Spec (Lower limit)],1,0),Id))</P> <P>Same this return is 0.&nbsp;</P> <P>Why is the resulting value not sum the value 1 return the loop if ?</P> Fri, 15 Nov 2024 21:58:20 GMT https://community.qlik.com/t5/QlikView/Why-is-the-output-value-0/m-p/1996430#M1225686 Sxbbb 2024-11-15T21:58:20Z