topic Re: Top Ranking in QlikView https://community.qlik.com/t5/QlikView/Top-Ranking/m-p/1393579#M820018 <HTML><HEAD></HEAD><BODY><P>Dear Venkat,</P><P></P><P></P><P>Can you share sample data so that we can help you in better way.</P><P></P><P>Thanks,</P><P>Mukram.</P></BODY></HTML> Mon, 14 Aug 2017 07:35:46 GMT mdmukramali 2017-08-14T07:35:46Z Top Ranking https://community.qlik.com/t5/QlikView/Top-Ranking/m-p/1393578#M820017 <HTML><HEAD></HEAD><BODY><P>I'm trying to get Top 5 <SPAN style="font-size: 10pt;">styles information for each division. Is there any help anyone could provide in achieving this. </SPAN></P><P></P><P>Example</P><P>Division 1 </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Style 1</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Style 2</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Style 3</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Style 4</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Style 5</P><P>Division 2</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Style 1</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Style 2</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Style 3</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Style 4</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Style 5</P><P></P><P>Thanks</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Top-Ranking/m-p/1393578#M820017 vnachiap 2020-11-25T16:16:04Z Re: Top Ranking https://community.qlik.com/t5/QlikView/Top-Ranking/m-p/1393579#M820018 <HTML><HEAD></HEAD><BODY><P>Dear Venkat,</P><P></P><P></P><P>Can you share sample data so that we can help you in better way.</P><P></P><P>Thanks,</P><P>Mukram.</P></BODY></HTML> Mon, 14 Aug 2017 07:35:46 GMT https://community.qlik.com/t5/QlikView/Top-Ranking/m-p/1393579#M820018 mdmukramali 2017-08-14T07:35:46Z Re: Top Ranking https://community.qlik.com/t5/QlikView/Top-Ranking/m-p/1393580#M820019 <HTML><HEAD></HEAD><BODY><P>If you have Data points metric in your DM. You can try sommething like below</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN lang="EN-US" style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: Calibri, sans-serif;"><STRONG>AGGR(IF(Rank(sum(Sales), 4)&lt;=5, Style), Style, <STRONG style="color: #3d3d3d; font-family: Calibri, sans-serif; font-size: 14.6667px;">Division</STRONG>)</STRONG></SPAN></P><P><SPAN lang="EN-US" style="font-weight: inherit; font-style: inherit; font-size: 11pt; font-family: Calibri, sans-serif;"><BR /></SPAN></P></BODY></HTML> Mon, 14 Aug 2017 07:39:05 GMT https://community.qlik.com/t5/QlikView/Top-Ranking/m-p/1393580#M820019 Anil_Babu_Samineni 2017-08-14T07:39:05Z