topic Re: Problem with Rank and Totals in QlikView https://community.qlik.com/t5/QlikView/Problem-with-Rank-and-Totals/m-p/1290505#M856981 <HTML><HEAD></HEAD><BODY><P>That works well. Thank you! </P></BODY></HTML> Fri, 03 Feb 2017 19:20:59 GMT 2017-02-03T19:20:59Z Problem with Rank and Totals https://community.qlik.com/t5/QlikView/Problem-with-Rank-and-Totals/m-p/1290503#M856979 <HTML><HEAD></HEAD><BODY><P>I'm having an issue using the Rank function in a pivot chart table. I'm trying to rank all customers according to their sales for the selected year and the previous year. <SPAN style="text-decoration: underline;">But I only want to display the top 5</SPAN>. I could live with a chart that shows only the first five lines -- and I get the desired rankings when I do this. But the totals reflect ALL customers, not just the Top 5.</P><P></P><P>When I change the Dimension Limit to show only the largest 5, I get the totals I want, but the previous year ranking is now relative to the top 5 only.</P><P></P><P>Do you see a way to get the ranking on the whole set, but the totals for the Top 5 only? See attached which has explanatory notes.</P><P></P><P>Thank you.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Problem-with-Rank-and-Totals/m-p/1290503#M856979 2020-11-25T16:16:04Z Re: Problem with Rank and Totals https://community.qlik.com/t5/QlikView/Problem-with-Rank-and-Totals/m-p/1290504#M856980 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You may use =MAX(AGGR(RANK(SUM({&lt;Customer=,Year={$(=Only(Year)-1)}&gt;}Sales)),Customer))</P><P>in the second chart.</P><P></P><P>Best regards,</P><P>Cosmina</P></BODY></HTML> Fri, 03 Feb 2017 18:34:07 GMT https://community.qlik.com/t5/QlikView/Problem-with-Rank-and-Totals/m-p/1290504#M856980 Anonymous 2017-02-03T18:34:07Z Re: Problem with Rank and Totals https://community.qlik.com/t5/QlikView/Problem-with-Rank-and-Totals/m-p/1290505#M856981 <HTML><HEAD></HEAD><BODY><P>That works well. Thank you! </P></BODY></HTML> Fri, 03 Feb 2017 19:20:59 GMT https://community.qlik.com/t5/QlikView/Problem-with-Rank-and-Totals/m-p/1290505#M856981 2017-02-03T19:20:59Z