Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
elena888
Specialist
Specialist

How to rank grouped values

Hi,

I have a table like this:

   

QTATeamZONE
50ChiaraA
60GiorgioB
80SaraD
500StefanoE
100ElenaA
200ValeriaB
300AntonioC
400EnzoD
9999LellaE
2000GiacomoF
70MarcoC

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:

TeamZONE
ElenaA
ValeriaB
AntonioC
EnzoD
LellaE
GiacomoF

Thank you,

Elena

1 Solution

Accepted Solutions
Oleg_Troyansky

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

View solution in original post

2 Replies
Oleg_Troyansky

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

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.