topic Re: Rank Function in QlikView https://community.qlik.com/t5/QlikView/Rank-Function/m-p/516792#M1135951 <HTML><HEAD></HEAD><BODY><P>=rank($(vAbsError)) and rank($(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">vAbsAccuracy</SPAN>))does not return what you want?</P></BODY></HTML> Wed, 23 Oct 2013 20:02:28 GMT Clever_Anjos 2013-10-23T20:02:28Z Rank Function https://community.qlik.com/t5/QlikView/Rank-Function/m-p/516791#M1135950 <HTML><HEAD></HEAD><BODY><P>I have attached my example model...</P><P></P><P>I want to apply rank function to calculated Error and Accuracy Column according to Slider.</P><P></P><P>Note:Error is calculated on a variable name vAbsError</P><P></P><P>and Accuracy in vAbsAccuracy.</P></BODY></HTML> Wed, 23 Oct 2013 19:18:55 GMT https://community.qlik.com/t5/QlikView/Rank-Function/m-p/516791#M1135950 suvechha_b 2013-10-23T19:18:55Z Re: Rank Function https://community.qlik.com/t5/QlikView/Rank-Function/m-p/516792#M1135951 <HTML><HEAD></HEAD><BODY><P>=rank($(vAbsError)) and rank($(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">vAbsAccuracy</SPAN>))does not return what you want?</P></BODY></HTML> Wed, 23 Oct 2013 20:02:28 GMT https://community.qlik.com/t5/QlikView/Rank-Function/m-p/516792#M1135951 Clever_Anjos 2013-10-23T20:02:28Z Re: Rank Function https://community.qlik.com/t5/QlikView/Rank-Function/m-p/516793#M1135952 <HTML><HEAD></HEAD><BODY><P>No it is not working...</P><P></P><P>Please check my example model....</P></BODY></HTML> Thu, 24 Oct 2013 07:00:53 GMT https://community.qlik.com/t5/QlikView/Rank-Function/m-p/516793#M1135952 suvechha_b 2013-10-24T07:00:53Z Re: Rank Function https://community.qlik.com/t5/QlikView/Rank-Function/m-p/516794#M1135953 <HTML><HEAD></HEAD><BODY><P>Can you please suggest how to apply rank function in tmy below expression:</P><P></P><P>sum(aggr(fabs(sum([Absolute Error])),[Product Code],[Fiscal Month],[Fiscal Year],Measure,[Division Product Manager Code]))</P></BODY></HTML> Thu, 24 Oct 2013 07:17:18 GMT https://community.qlik.com/t5/QlikView/Rank-Function/m-p/516794#M1135953 suvechha_b 2013-10-24T07:17:18Z Re: Rank Function https://community.qlik.com/t5/QlikView/Rank-Function/m-p/516795#M1135954 <HTML><HEAD></HEAD><BODY><P>Well,</P><P>Maybe I´m missing something.</P><P>It seems working to me</P><P></P><P><IMG alt="Capturar.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/48083_Capturar.PNG.png" style="width: 620px; height: 307px;" /></P></BODY></HTML> Thu, 24 Oct 2013 10:52:17 GMT https://community.qlik.com/t5/QlikView/Rank-Function/m-p/516795#M1135954 Clever_Anjos 2013-10-24T10:52:17Z