https://community.qlik.com/t5/App-Development/Count-if-lt/m-p/1822176#M67422 <P>Want to count all costs that are below -5000. Any easy ways to do this? The function below did not work.</P><P>if(cost&lt;=-5000,count(cost))</P> Wed, 14 Jul 2021 18:41:21 GMT kryan 2021-07-14T18:41:21Z https://community.qlik.com/t5/App-Development/Count-if-lt/m-p/1822176#M67422 <P>Want to count all costs that are below -5000. Any easy ways to do this? The function below did not work.</P><P>if(cost&lt;=-5000,count(cost))</P> Wed, 14 Jul 2021 18:41:21 GMT https://community.qlik.com/t5/App-Development/Count-if-lt/m-p/1822176#M67422 kryan 2021-07-14T18:41:21Z https://community.qlik.com/t5/App-Development/Count-if-lt/m-p/1822183#M67423 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/145601">@kryan</a>, I recommend to avoid IF() function when possible. Try using set analysis instead (and it will have much better performance):</P><LI-CODE lang="markup">Count({&lt;cost = {"&lt;=-5000"}&gt;} cost)</LI-CODE><P>JG</P> Wed, 14 Jul 2021 19:26:06 GMT https://community.qlik.com/t5/App-Development/Count-if-lt/m-p/1822183#M67423 JuanGerardo 2021-07-14T19:26:06Z