Rank Ignoring Selections

emeehleder — Wed, 10 Apr 2019 15:53:24 GMT

I have a question regarding using rank while ignoring filter selections.

I have 12 metrics on my app that all have different point values and these are added to create "total points" which is then being ranked by using rank([Total Points]) just referencing the column where all metrics are added together. If a user selects specific agents, I don't want the rank to change.

An example of two of the equations are below - the variables referenced are all fractile calcuations

if(Aggr((sum(TotalCallsHandled)-sum(ManualCalls))/sum(Utilization),MonthApp,AppAgent)>=vCPH90,5,
if(Aggr((sum(TotalCallsHandled)-sum(ManualCalls))/sum(Utilization),MonthApp,AppAgent>=vCPH75,4,
if(Aggr((sum(TotalCallsHandled)sum(ManualCalls))/sum(Utilization),MonthApp,AppAgent)>=vCPH49,3,
if(Aggr((sum(TotalCallsHandled)-sum(ManualCalls))/sum(Utilization),MonthApp,AppAgent)<vCPH49,2))))))

if(Aggr(sum(ConvFlag)/sum(CustCount),MonthApp,AppAgent)>=vConvPay90,10,
if(Aggr(sum(ConvFlag)/sum(CustCount),MonthApp,AppAgent)>=vConvPay75,8,
if(Aggr(sum(ConvFlag)/sum(CustCount),MonthApp,AppAgent)>=vConvPay49,6,
if(Aggr(sum(ConvFlag)/sum(CustCount),MonthApp,AppAgent)<vConvPay49,4,4))))

Thanks!

Re: Rank Ignoring Selections

dplr-rn — Wed, 10 Apr 2019 20:49:15 GMT

No exactly clear how you are ranking things.
but if you want to ignore selection for a particular filter e.g. Agent.
add below set analysis in your expressions
{<Agent=>}
e.g.
Sum({<Agent=>}Sales)

topic Re: Rank Ignoring Selections in QlikView

Rank Ignoring Selections

Re: Rank Ignoring Selections