topic Re: Problem with aggr function in QlikView https://community.qlik.com/t5/QlikView/Problem-with-aggr-function/m-p/1186194#M383791 <HTML><HEAD></HEAD><BODY><P>What are the expressions that you are using here? I think you are using Aggr() function, but it would be better to use Count(TOTAL &lt;Region&gt; .....) for denominator. Although, if you do want to use Aggr(), you need to use NODISTINCT -&gt; Aggr(NODISTINCT ....)</P></BODY></HTML> Fri, 16 Sep 2016 16:01:51 GMT sunny_talwar 2016-09-16T16:01:51Z Problem with aggr function https://community.qlik.com/t5/QlikView/Problem-with-aggr-function/m-p/1186193#M383790 <HTML><HEAD></HEAD><BODY><P><IMG alt="prb.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/137666_prb.PNG" style="height: auto;" /></P><P>Hi All</P><P></P><P>I want to calculate % for above rows i.e. 367/5793 and 5426/5793</P><P>I used aggr function for calculating 5793, but it is not populating in all rows </P><P>please help.. </P></BODY></HTML> Fri, 16 Sep 2016 06:11:09 GMT https://community.qlik.com/t5/QlikView/Problem-with-aggr-function/m-p/1186193#M383790 2016-09-16T06:11:09Z Re: Problem with aggr function https://community.qlik.com/t5/QlikView/Problem-with-aggr-function/m-p/1186194#M383791 <HTML><HEAD></HEAD><BODY><P>What are the expressions that you are using here? I think you are using Aggr() function, but it would be better to use Count(TOTAL &lt;Region&gt; .....) for denominator. Although, if you do want to use Aggr(), you need to use NODISTINCT -&gt; Aggr(NODISTINCT ....)</P></BODY></HTML> Fri, 16 Sep 2016 16:01:51 GMT https://community.qlik.com/t5/QlikView/Problem-with-aggr-function/m-p/1186194#M383791 sunny_talwar 2016-09-16T16:01:51Z