Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
achakilam1022
Creator II
Creator II

Finding 40%-90% range

Hi all,

How can I rank the agents (top to bottom) and then find who are in 40-90%  performance range rank wise(Transfers/Billable metric) in each campaign and then find the median of all the Transfer/Billable values in this 40-90% range which would be the target for that campaign? attached is the sample data.

Thanks!

5 Replies
zebhashmi
Specialist
Specialist

you can use something like that I will do it for you in while

concat(Class(Aggr(Transfers/Billable*100,[Agent Name]),2), '-')

zebhashmi
Specialist
Specialist

1.PNG2.PNG3.PNGMaybe something like that

achakilam1022
Creator II
Creator II
Author

Hi Jahanzeb,

I appreciate your response.

I want to define a target for each campaign by ranking the agents within each campaign based on Transfer/Billable rate. If there are 10 agents in a campaign, I want to consider transfer/billable rates of agents who rank between 4 and 9 (ranked by transfer/billable rate - high to low) in that campaign and then find a median of these rates.

Sorry if my original question was unclear.

Thanks!

zebhashmi
Specialist
Specialist

Ya, I am still not getting it very well. sorry about that.

what is in your target sheet you can achieve like this but I am not getting the next step.

1.PNG

achakilam1022
Creator II
Creator II
Author

Thanks for your help, Jahanzeb!