# 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:
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

 User Documents Reviewed Hours Productivity Differrence Marshal 65 6.5 10.00 ? Lloyd 1507 96.5 15.62 ? Bendict 1232 89 13.84 ? Rachel 600 32 18.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
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

7 Replies
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

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

Specialist
Author

Thank you guys for your help. 🙂

Specialist
Author

PFA

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

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.

Specialist
Author

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

Community Browser