https://community.qlik.com/t5/QlikView/Aggr-Issue-With-Hierarchy-Level/m-p/1827233#M1214062 <P>Hi</P><P>Count is based on AMName? If so, try like below</P><P><SPAN>Count(total&lt;AMName&gt; distinct AMCoachingSystemUserId)/Count(total&lt;AMName&gt; distinct [%_SystemUserId])</SPAN></P> Sat, 07 Aug 2021 01:19:12 GMT MayilVahanan 2021-08-07T01:19:12Z https://community.qlik.com/t5/QlikView/Aggr-Issue-With-Hierarchy-Level/m-p/1827117#M1214054 <P>Hi All,</P><P>While creating the table chart with hierarchy level, am facing the issue with AGGR function. When I select the One AMName, last field value % is showing correctly as 71.4%. (Eg. Sayed Asif Iqbal).</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="dineshm030_0-1628255020871.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/59795iBFEF8360DAAD961F/image-size/medium?v=v2&amp;px=400" role="button" title="dineshm030_0-1628255020871.png" alt="dineshm030_0-1628255020871.png" /></span></P><P>Eg. Samir Kazi (50%) (3/6)</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="dineshm030_2-1628255367441.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/59797i8262266E95A2C001/image-size/medium?v=v2&amp;px=400" role="button" title="dineshm030_2-1628255367441.png" alt="dineshm030_2-1628255367441.png" /></span></P><P>&nbsp;</P><P>Without selection it is taking overall count for all AMName (87/124). Without AMName selection it should show 71.4 % (5/7). Below is the expression using:</P><P>Count(total distinct AMCoachingSystemUserId)/Count(total distinct [%_SystemUserId])</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="dineshm030_1-1628255146566.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/59796i974FF5328BEE3E2C/image-size/medium?v=v2&amp;px=400" role="button" title="dineshm030_1-1628255146566.png" alt="dineshm030_1-1628255146566.png" /></span></P><P>Kindly help me out.</P><P>Thanks in advance.</P><P>Regards,</P><P>Dinesh Kumar Mani.</P> Fri, 06 Aug 2021 13:10:51 GMT https://community.qlik.com/t5/QlikView/Aggr-Issue-With-Hierarchy-Level/m-p/1827117#M1214054 dineshm030 2021-08-06T13:10:51Z https://community.qlik.com/t5/QlikView/Aggr-Issue-With-Hierarchy-Level/m-p/1827233#M1214062 <P>Hi</P><P>Count is based on AMName? If so, try like below</P><P><SPAN>Count(total&lt;AMName&gt; distinct AMCoachingSystemUserId)/Count(total&lt;AMName&gt; distinct [%_SystemUserId])</SPAN></P> Sat, 07 Aug 2021 01:19:12 GMT https://community.qlik.com/t5/QlikView/Aggr-Issue-With-Hierarchy-Level/m-p/1827233#M1214062 MayilVahanan 2021-08-07T01:19:12Z