topic Re: AGGR Function in QlikView https://community.qlik.com/t5/QlikView/AGGR-Function/m-p/847233#M297381 <HTML><HEAD></HEAD><BODY><P>=Count(AcctNum)/Count(Total &lt;ProductCode&gt; AcctNum)</P><P>Use Distinct if necessary..</P></BODY></HTML> Thu, 02 Apr 2015 15:41:09 GMT MK_QSL 2015-04-02T15:41:09Z AGGR Function https://community.qlik.com/t5/QlikView/AGGR-Function/m-p/847232#M297380 <HTML><HEAD></HEAD><BODY><P>I am trying to create a relative frequency using the AGGR function.&nbsp; I have a snapshot of the data as it is exported to Excel.</P><P></P><P>I would like to divide each count by the total count for each product code.&nbsp; All rows other than a randomly chosen row are showing up as missing.</P><P></P><P><IMG alt="aggr.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/82823_aggr.png" style="height: auto;" /></P></BODY></HTML> Thu, 02 Apr 2015 15:37:20 GMT https://community.qlik.com/t5/QlikView/AGGR-Function/m-p/847232#M297380 Anonymous 2015-04-02T15:37:20Z Re: AGGR Function https://community.qlik.com/t5/QlikView/AGGR-Function/m-p/847233#M297381 <HTML><HEAD></HEAD><BODY><P>=Count(AcctNum)/Count(Total &lt;ProductCode&gt; AcctNum)</P><P>Use Distinct if necessary..</P></BODY></HTML> Thu, 02 Apr 2015 15:41:09 GMT https://community.qlik.com/t5/QlikView/AGGR-Function/m-p/847233#M297381 MK_QSL 2015-04-02T15:41:09Z