https://community.qlik.com/t5/App-Development/Agrr-with-count-and-sum/m-p/2020319#M84253 <P>Thank you for reply!</P> <P>&nbsp;</P> <P>my values ​​are still coming in null. the idea is that everything I'm counting within that sum of counts is aggregated by nr_client, I don't know if the aggr I'm doing is incorrect.</P> Wed, 28 Dec 2022 13:35:57 GMT lucasx15 2022-12-28T13:35:57Z https://community.qlik.com/t5/App-Development/Agrr-with-count-and-sum/m-p/2020147#M84244 <P>Hello everybody. I have a doubt, how could Aggr use a sum within two count fields? My expression is like this:. What would be wrong?</P> <P>&nbsp;</P> <P>&nbsp;</P> <LI-CODE lang="markup"> =COUNT(AGGR({&lt;CD_HISTORY={57,89,10}&gt;} COUNT( {&lt;CD_PROT={3535},FL_TYPE={'1 - ALT'}&gt;} %NR_PRESCR_PRODUCT) + COUNT({&lt;FL_TYPE={'1 - ALT'}&gt;} NR_SEQUENCE.SCALE)) DISTINCT NR_CLIENT)</LI-CODE> <P>&nbsp;</P> Wed, 28 Dec 2022 10:25:31 GMT https://community.qlik.com/t5/App-Development/Agrr-with-count-and-sum/m-p/2020147#M84244 lucasx15 2022-12-28T10:25:31Z https://community.qlik.com/t5/App-Development/Agrr-with-count-and-sum/m-p/2020224#M84246 <P>it seems you miss the field you want to use as the dimension in the AGGR function&nbsp;</P> Wed, 28 Dec 2022 08:32:42 GMT https://community.qlik.com/t5/App-Development/Agrr-with-count-and-sum/m-p/2020224#M84246 lironbaram 2022-12-28T08:32:42Z https://community.qlik.com/t5/App-Development/Agrr-with-count-and-sum/m-p/2020319#M84253 <P>Thank you for reply!</P> <P>&nbsp;</P> <P>my values ​​are still coming in null. the idea is that everything I'm counting within that sum of counts is aggregated by nr_client, I don't know if the aggr I'm doing is incorrect.</P> Wed, 28 Dec 2022 13:35:57 GMT https://community.qlik.com/t5/App-Development/Agrr-with-count-and-sum/m-p/2020319#M84253 lucasx15 2022-12-28T13:35:57Z