topic Difference between the Top Performer and rest in QlikView

Difference between the Top Performer and rest

renjithpl — Thu, 10 Feb 2011 11:25:52 GMT

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

Difference between the Top Performer and rest

lironbaram — Thu, 10 Feb 2011 11:42:22 GMT

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

Difference between the Top Performer and rest

matt_crowther — Thu, 10 Feb 2011 13:00:26 GMT

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

Difference between the Top Performer and rest

renjithpl — Fri, 11 Feb 2011 07:04:42 GMT

Thank you guys for your help. 🙂

Difference between the Top Performer and rest

renjithpl — Mon, 14 Feb 2011 10:05:43 GMT

PFA

Difference between the Top Performer and rest

renjithpl — Mon, 14 Feb 2011 10:07:31 GMT

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

Difference between the Top Performer and rest

Anonymous — Mon, 14 Feb 2011 10:15:44 GMT

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.

Difference between the Top Performer and rest

renjithpl — Mon, 14 Feb 2011 10:24:02 GMT

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