How to rank grouped values

[Anonymous]

Hi,

I have a table like this:

QTA	Team	ZONE
50	Chiara	A
60	Giorgio	B
80	Sara	D
500	Stefano	E
100	Elena	A
200	Valeria	B
300	Antonio	C
400	Enzo	D
9999	Lella	E
2000	Giacomo	F
70	Marco	C

I would like to select or have as a calculated dimension in a pivot (or to calculate in script) the team, for each zone, which has the biggest QTA.

So, the output would be:

Team	ZONE
Elena	A
Valeria	B
Antonio	C
Enzo	D
Lella	E
Giacomo	F

Thank you,

Elena

[Oleg_Troyansky · Accepted solution]

Hi Elena,

Check out this blog article, I think it will help with your problem:

QlikView Blog Q-Tip #5 – Show Top Performers. Common but not too trivial. | Natural Synergies

Also, check out my new book QlikView Your Business. In the book, I teach many advanced techniques, this one included, of using Advanced Aggregation and Advanced Set Analysis.

cheers,

Oleg Troyansky

Check out my new book QlikView Your Business: An expert guide to Business Discovery with QlikView an...

[jolivares]

I suggest you read all about the post of Oleg, he is one of the best.

But you can try to make a dimension of Zone and an expression like this:

FirstSortedValue(Team,-Aggr(Max(QTA),Team))

If you want to show the table Team-Zone, flip the columns.