topic Top 6 Max Sales in QlikView https://community.qlik.com/t5/QlikView/Top-6-Max-Sales/m-p/1292262#M871411 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 8pt;">Hi Guys,</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">I am trying to show top max sale, I have two dimensions Region and Company. I have descending order top max to lower sales.</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">I am trying to put this on dimension level.</SPAN></P><P></P><P>=aggr(if(</P><P>max(rank(Sum({$&lt;Month={$(=Month)}&gt;} Sales)))</P><P>&gt;=</P><P>max(rank(Sum({$&lt;Month={$(=Month)}&gt;} Sales))-5), Company) , Region, Company)</P><P></P><P></P><P><SPAN style="font-size: 8pt;">Could you please advise me what I am missing?</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Kind regards,</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Farrukh</SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z Top 6 Max Sales https://community.qlik.com/t5/QlikView/Top-6-Max-Sales/m-p/1292262#M871411 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 8pt;">Hi Guys,</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">I am trying to show top max sale, I have two dimensions Region and Company. I have descending order top max to lower sales.</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">I am trying to put this on dimension level.</SPAN></P><P></P><P>=aggr(if(</P><P>max(rank(Sum({$&lt;Month={$(=Month)}&gt;} Sales)))</P><P>&gt;=</P><P>max(rank(Sum({$&lt;Month={$(=Month)}&gt;} Sales))-5), Company) , Region, Company)</P><P></P><P></P><P><SPAN style="font-size: 8pt;">Could you please advise me what I am missing?</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Kind regards,</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Farrukh</SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Top-6-Max-Sales/m-p/1292262#M871411 Anonymous 2020-11-25T16:16:04Z Re: Top 6 Max Sales https://community.qlik.com/t5/QlikView/Top-6-Max-Sales/m-p/1292263#M871412 <HTML><HEAD></HEAD><BODY><P>Top 5 sales overall or top 5 sales per Region?</P></BODY></HTML> Tue, 22 Nov 2016 16:32:15 GMT https://community.qlik.com/t5/QlikView/Top-6-Max-Sales/m-p/1292263#M871412 sunny_talwar 2016-11-22T16:32:15Z Re: Top 6 Max Sales https://community.qlik.com/t5/QlikView/Top-6-Max-Sales/m-p/1292264#M871414 <HTML><HEAD></HEAD><BODY><P>Top 6 sales overall</P></BODY></HTML> Tue, 22 Nov 2016 16:33:35 GMT https://community.qlik.com/t5/QlikView/Top-6-Max-Sales/m-p/1292264#M871414 Anonymous 2016-11-22T16:33:35Z Re: Top 6 Max Sales https://community.qlik.com/t5/QlikView/Top-6-Max-Sales/m-p/1292265#M871415 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>=Aggr(If(Rank(TOTAL Sum({$&lt;Month={$(=Month)}&gt;} Sales)) &lt; 7, Company), Region, Company)</STRONG></P></BODY></HTML> Tue, 22 Nov 2016 16:37:02 GMT https://community.qlik.com/t5/QlikView/Top-6-Max-Sales/m-p/1292265#M871415 sunny_talwar 2016-11-22T16:37:02Z