topic help needed on expression in QlikView https://community.qlik.com/t5/QlikView/help-needed-on-expression/m-p/355157#M131826 <HTML><HEAD></HEAD><BODY><P> I need this in expression only...:(</P></BODY></HTML> Wed, 16 May 2012 19:01:56 GMT sonikajain 2012-05-16T19:01:56Z help needed on expression https://community.qlik.com/t5/QlikView/help-needed-on-expression/m-p/355155#M131824 <HTML><HEAD></HEAD><BODY><P> Dear all,I need to do a calculation on columns Division and Balance , such that - " for Divisions sorted on sum(balance), the sum of balance for top 5 divisions."</P><P></P><P>Am using the expression -sum({&lt;DIVISION = {"=rank(aggr(sum(BALANCE),DIVISION))&lt;= 6)"}&gt;}BALANCE), but it seems to fail as the rank function returns a number, and I need the Divisions for top 5 ranks.</P><P></P><P>Please help me on this expression.</P></BODY></HTML> Wed, 16 May 2012 16:53:58 GMT https://community.qlik.com/t5/QlikView/help-needed-on-expression/m-p/355155#M131824 sonikajain 2012-05-16T16:53:58Z help needed on expression https://community.qlik.com/t5/QlikView/help-needed-on-expression/m-p/355156#M131825 <HTML><HEAD></HEAD><BODY><P>Maybe shift the Aggr() and Rank() into the dimensions and then just have Sum(BALANCE) in the expression?</P></BODY></HTML> Wed, 16 May 2012 17:19:59 GMT https://community.qlik.com/t5/QlikView/help-needed-on-expression/m-p/355156#M131825 Jason_Michaelides 2012-05-16T17:19:59Z help needed on expression https://community.qlik.com/t5/QlikView/help-needed-on-expression/m-p/355157#M131826 <HTML><HEAD></HEAD><BODY><P> I need this in expression only...:(</P></BODY></HTML> Wed, 16 May 2012 19:01:56 GMT https://community.qlik.com/t5/QlikView/help-needed-on-expression/m-p/355157#M131826 sonikajain 2012-05-16T19:01:56Z