Ranking

Thu, 17 Jan 2013 20:30:00 GMT

Hello All,

I have an issue where i have to generate rank for the below expression

= sum({<$(vClntNum)=>}Rev)-(fabs(sum({<$(vClntNum)=,ActivityType={'Revenue'}>}Expense))+sum({<$(vClntNum) = ,MasterActivityType={'Expense','ContentServices','Support'}>}Expense)))

i tried someting like below and it is not working.

=aggr(rank((sum({<$(vClntNum)=>}Net)-(fabs(sum({<$(vClntNum)=,MasterActivityType={'Revenue'}>}Expense))+

sum({<$(vClntNum) = ,MasterActivityType={'Expense','ContentServices','Support'}>}Expense))),4),$(vClntNum))),4)$(vClntNum)

Thanks for the help.

topic Ranking in QlikView

Ranking