topic Decile Analysis in QlikView https://community.qlik.com/t5/QlikView/Decile-Analysis/m-p/276988#M1183359 <HTML><HEAD></HEAD><BODY><P>Hello. I will like to ask how do i replace "aggr", if i want to perform decile analysis in the "load script" instead? </P><P></P><P>Typically, it will look like this </P><P>(For example)</P><P></P><P>=if(AGGR(sum(montant),compte_id, week)&lt;=<STRONG>aggr(NODISTINCT</STRONG> fractile(TOTAL &lt;week&gt; aggr(sum(montant), compte_id, week),0.80),<STRONG>week)</STRONG>,'P-80%',</P><P>if(aggr(sum(montant), compte_id, week)&lt;=<STRONG>aggr(NODISTINCT</STRONG> fractile(TOTAL &lt;week&gt; aggr(sum(montant), compte_id, week),0.96)<STRONG>,week)</STRONG>,'M-16%','G-4%'))</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 26 Oct 2011 14:39:13 GMT 2011-10-26T14:39:13Z Decile Analysis https://community.qlik.com/t5/QlikView/Decile-Analysis/m-p/276988#M1183359 <HTML><HEAD></HEAD><BODY><P>Hello. I will like to ask how do i replace "aggr", if i want to perform decile analysis in the "load script" instead? </P><P></P><P>Typically, it will look like this </P><P>(For example)</P><P></P><P>=if(AGGR(sum(montant),compte_id, week)&lt;=<STRONG>aggr(NODISTINCT</STRONG> fractile(TOTAL &lt;week&gt; aggr(sum(montant), compte_id, week),0.80),<STRONG>week)</STRONG>,'P-80%',</P><P>if(aggr(sum(montant), compte_id, week)&lt;=<STRONG>aggr(NODISTINCT</STRONG> fractile(TOTAL &lt;week&gt; aggr(sum(montant), compte_id, week),0.96)<STRONG>,week)</STRONG>,'M-16%','G-4%'))</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 26 Oct 2011 14:39:13 GMT https://community.qlik.com/t5/QlikView/Decile-Analysis/m-p/276988#M1183359 2011-10-26T14:39:13Z