Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
renjithpl
Specialist
Specialist

Difference between the Top Performer and rest

Hi All,

I want to find out the difference between the Top Performer and the rest of the User,

This is my straight table

UserDocuments ReviewedHoursProductivityDifferrence
Marshal656.510.00?
Lloyd150796.515.62?
Bendict12328913.84?
Rachel6003218.75?


To get the Productivity the expression is =Sum([Documents Reviewed]) / Sum(Hours),

So Rachel has the top Productivity (18.75), In my Difference Column i want a formula, that should calculate like below:

Marshal - (18.75 - 10.00 ) ans: 8.75
Llyod - (18.75 - 15.62) ans: 3.13
Bendict - (18.75 - 13.84) ans: 4.91
Rachel - (18.75 - 18.75) ans: 0.00

Thanks in advance

Ranjit

1 Solution

Accepted Solutions
lironbaram
Partner
Partner

hei

attcah is an example of what you asked for

i added a variable which calculate the best score diregarding selections in user filed

hope it helps you

View solution in original post

7 Replies
lironbaram
Partner
Partner

hei

attcah is an example of what you asked for

i added a variable which calculate the best score diregarding selections in user filed

hope it helps you

matt_crowther
Luminary Alumni
Luminary Alumni

Ranjit,

Attached is an alternate solution to that in the previous post that may be a little bit more flexible (Both will work & the variable solution is a good one).

I've used the top() function to refer to the highest scoring individual allowing for the calculation to be carried out entirely within the object.

Hope that helps,

Matt - Visual Analytics Ltd

renjithpl
Specialist
Specialist
Author

Thank you guys for your help. 🙂

renjithpl
Specialist
Specialist
Author

PFA

renjithpl
Specialist
Specialist
Author

Hi Roi, when i tested first it worked for me, but can you see my latest attachement, please tell me what is wrong it that formula. I have made exactly what you said.

Thanks

dennisnet
Partner
Partner

You forgot to add the Variable

Ctrl + Alt + v

Add: MaxProdctivtiy

Definition:
=max({<User=>}aggr(sum({<User=>}DocumentReviews)/Sum ({<User=>}Hours),User))

That should work.

renjithpl
Specialist
Specialist
Author

yes yes... i forgot thanks a lot...