https://community.qlik.com/t5/QlikView/Count-if/m-p/1648511#M456148 <P>I've got it now, sorry</P><P>&nbsp;</P><P>=Count({&lt;Availability= {"=Avg({&lt; $(<EM>vSetMTD</EM>)&gt;} Availability) &lt; System_Norm "}&gt;} SystemID)</P> Tue, 19 Nov 2019 12:57:15 GMT EsmeeM 2019-11-19T12:57:15Z https://community.qlik.com/t5/QlikView/Count-if/m-p/1648488#M456147 <P>Hi all,</P><P>I'm trying to return a count of the systems that perform under norm of the last month's data.&nbsp;I have a table with SystemIDs, Dates and availability values.</P><P>So far I have tried the following syntax with no good results:</P><P>=Count({&lt;Availability = {"&lt;=0.99"}, $(vSetMTD) &gt;} SystemID)</P><P><EM>(Result is 0)</EM></P><P>It also does not work without the last month <EM>$(vSetMTD)&nbsp;</EM>restriction.&nbsp;</P><P>Can anyone tell me what I am doing wrong here?</P><P>Thanks in advance!</P> Sat, 16 Nov 2024 01:54:25 GMT https://community.qlik.com/t5/QlikView/Count-if/m-p/1648488#M456147 EsmeeM 2024-11-16T01:54:25Z https://community.qlik.com/t5/QlikView/Count-if/m-p/1648511#M456148 <P>I've got it now, sorry</P><P>&nbsp;</P><P>=Count({&lt;Availability= {"=Avg({&lt; $(<EM>vSetMTD</EM>)&gt;} Availability) &lt; System_Norm "}&gt;} SystemID)</P> Tue, 19 Nov 2019 12:57:15 GMT https://community.qlik.com/t5/QlikView/Count-if/m-p/1648511#M456148 EsmeeM 2019-11-19T12:57:15Z