Show Top Fee in Dimension

[#1]

Hi All,

Is there a way I can show top Bank who made the most fees in the Dimension Calculation?

Load * Inline [

Bank, Product, Fee,

JPM, IPO, 10

JPM, FO, 20

JPM, Debt, 30

MS, IPO, 9

MS, FO, 21

MS, Debt, 32

GS, IPO, 8

GS, FO, 19

GS, Debt, 33

];

So for example,

I want to show Product, Total Fees and which bank made the most (or ranked #1) by each product

[sunny_talwar · Accepted solution]

May be try this:

FirstSortedValue(Bank, -Aggr(Sum(Fee), Product, Bank))

[Gysbert_Wassenaar]

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