topic Please help me out in Rank Function. in QlikView https://community.qlik.com/t5/QlikView/Please-help-me-out-in-Rank-Function/m-p/515872#M1135371 <HTML><HEAD></HEAD><BODY><P>How to put Rank function in the below expression.</P><P></P><P></P><P>sum(aggr(fabs(sum([Absolute Error])),[Product Code],[Fiscal Month],[Fiscal Year],Measure,[Division Product Manager Code]))</P><P></P><P></P><P>Note : vError is a variable , calculating the below expression,</P><P></P><P>sum(aggr(fabs(sum([Absolute Error])),[Product Code],[Fiscal Month],[Fiscal Year],Measure,[Division Product Manager Code]))</P><P></P><P>$(vRankNo) is the variable defining number 25.</P><P></P><P>I have already given my model in the below link: name example.qvw</P><P></P><P><A _jive_internal="true" href="https://community.qlik.com/message/411018#411018">http://community.qlik.com/message/411018#411018</A></P></BODY></HTML> Thu, 24 Oct 2013 08:20:12 GMT suvechha_b 2013-10-24T08:20:12Z Please help me out in Rank Function. https://community.qlik.com/t5/QlikView/Please-help-me-out-in-Rank-Function/m-p/515872#M1135371 <HTML><HEAD></HEAD><BODY><P>How to put Rank function in the below expression.</P><P></P><P></P><P>sum(aggr(fabs(sum([Absolute Error])),[Product Code],[Fiscal Month],[Fiscal Year],Measure,[Division Product Manager Code]))</P><P></P><P></P><P>Note : vError is a variable , calculating the below expression,</P><P></P><P>sum(aggr(fabs(sum([Absolute Error])),[Product Code],[Fiscal Month],[Fiscal Year],Measure,[Division Product Manager Code]))</P><P></P><P>$(vRankNo) is the variable defining number 25.</P><P></P><P>I have already given my model in the below link: name example.qvw</P><P></P><P><A _jive_internal="true" href="https://community.qlik.com/message/411018#411018">http://community.qlik.com/message/411018#411018</A></P></BODY></HTML> Thu, 24 Oct 2013 08:20:12 GMT https://community.qlik.com/t5/QlikView/Please-help-me-out-in-Rank-Function/m-p/515872#M1135371 suvechha_b 2013-10-24T08:20:12Z