Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

achakilam1022
Contributor

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
Valued Contributor

Re: Finding 40%-90% range

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

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

zebhashmi
Valued Contributor

Re: Finding 40%-90% range

1.PNG2.PNG3.PNGMaybe something like that

achakilam1022
Contributor

Re: Finding 40%-90% range

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
Valued Contributor

Re: Finding 40%-90% range

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
Contributor

Re: Finding 40%-90% range

Thanks for your help, Jahanzeb!

Community Browser