Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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), '-')

Highlighted
Specialist
Specialist

1.PNG2.PNG3.PNGMaybe something like that

Highlighted
Creator II
Creator II

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!

Highlighted
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

Highlighted
Creator II
Creator II

Thanks for your help, Jahanzeb!