topic Re: Ranking (Ignoring 2nd dimension) in QlikView https://community.qlik.com/t5/QlikView/Ranking-Ignoring-2nd-dimension/m-p/1229160#M391864 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny. It works..</P></BODY></HTML> Fri, 25 Nov 2016 12:41:33 GMT 2016-11-25T12:41:33Z Ranking (Ignoring 2nd dimension) https://community.qlik.com/t5/QlikView/Ranking-Ignoring-2nd-dimension/m-p/1229158#M391862 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>In the attached file , I am ranking as per customer.</P><P></P><P>As for customer 8 which is at rank 1, i want all brands also to get same rank which is one.</P><P></P><P>Then all brands with customer 7 should have rank 2....</P><P></P><P>What is the expression to achieve above requirement.</P></BODY></HTML> Fri, 25 Nov 2016 12:27:22 GMT https://community.qlik.com/t5/QlikView/Ranking-Ignoring-2nd-dimension/m-p/1229158#M391862 2016-11-25T12:27:22Z Re: Ranking (Ignoring 2nd dimension) https://community.qlik.com/t5/QlikView/Ranking-Ignoring-2nd-dimension/m-p/1229159#M391863 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG>=Aggr(<SPAN style="color: #ff0000;">NODISTINCT</SPAN> rank(sum([Sales]),[Customer]),[Customer])</STRONG></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/144864_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Fri, 25 Nov 2016 12:35:41 GMT https://community.qlik.com/t5/QlikView/Ranking-Ignoring-2nd-dimension/m-p/1229159#M391863 sunny_talwar 2016-11-25T12:35:41Z Re: Ranking (Ignoring 2nd dimension) https://community.qlik.com/t5/QlikView/Ranking-Ignoring-2nd-dimension/m-p/1229160#M391864 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny. It works..</P></BODY></HTML> Fri, 25 Nov 2016 12:41:33 GMT https://community.qlik.com/t5/QlikView/Ranking-Ignoring-2nd-dimension/m-p/1229160#M391864 2016-11-25T12:41:33Z