topic Re: Show Top Fee in Dimension in QlikView https://community.qlik.com/t5/QlikView/Show-Top-Fee-in-Dimension/m-p/1109937#M897848 <HTML><HEAD></HEAD><BODY><P>May be try this:</P><P></P><P><STRONG>FirstSortedValue(Bank, -Aggr(Sum(Fee), Product, Bank))</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/131968_Capture.PNG" style="height: auto;" /><BR /></STRONG></P></BODY></HTML> Wed, 20 Jul 2016 15:41:44 GMT sunny_talwar 2016-07-20T15:41:44Z Show Top Fee in Dimension https://community.qlik.com/t5/QlikView/Show-Top-Fee-in-Dimension/m-p/1109936#M897847 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Is there a way I can show top Bank who made the most fees in the Dimension Calculation?</P><P></P><P>Load * Inline [</P><P>Bank, Product, Fee,</P><P>JPM, IPO, 10</P><P>JPM, FO, 20</P><P>JPM, Debt, 30</P><P>MS, IPO, 9</P><P>MS, FO, 21</P><P>MS, Debt, 32</P><P>GS, IPO, 8</P><P>GS, FO, 19</P><P>GS, Debt, 33</P><P>];</P><P></P><P>So for example,</P><P></P><P>I want to show Product, Total Fees and which bank made the most (or ranked #1) by each product</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Show-Top-Fee-in-Dimension/m-p/1109936#M897847 2020-11-25T16:16:04Z Re: Show Top Fee in Dimension https://community.qlik.com/t5/QlikView/Show-Top-Fee-in-Dimension/m-p/1109937#M897848 <HTML><HEAD></HEAD><BODY><P>May be try this:</P><P></P><P><STRONG>FirstSortedValue(Bank, -Aggr(Sum(Fee), Product, Bank))</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/131968_Capture.PNG" style="height: auto;" /><BR /></STRONG></P></BODY></HTML> Wed, 20 Jul 2016 15:41:44 GMT https://community.qlik.com/t5/QlikView/Show-Top-Fee-in-Dimension/m-p/1109937#M897848 sunny_talwar 2016-07-20T15:41:44Z Re: Show Top Fee in Dimension https://community.qlik.com/t5/QlikView/Show-Top-Fee-in-Dimension/m-p/1109938#M897850 <HTML><HEAD></HEAD><BODY><P>See this blog post: <A href="http://www.naturalsynergies.com/q-tip-5-show-top-performers-common-but-not-too-trivial/" title="http://www.naturalsynergies.com/q-tip-5-show-top-performers-common-but-not-too-trivial/">QlikView Blog Q-Tip #5 – Show Top Performers. Common but not too trivial. | Natural Synergies</A></P></BODY></HTML> Wed, 20 Jul 2016 15:42:42 GMT https://community.qlik.com/t5/QlikView/Show-Top-Fee-in-Dimension/m-p/1109938#M897850 Gysbert_Wassenaar 2016-07-20T15:42:42Z