Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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.