topic How to use Rank function to show top brands? in QlikView https://community.qlik.com/t5/QlikView/How-to-use-Rank-function-to-show-top-brands/m-p/951256#M327186 <HTML><HEAD></HEAD><BODY><P>Hello Friends,</P><P>Can any one tell me how to use Rank function in dimension of pivot table to show top Brands.</P><P>As shown in attached screen shot in first column there is a cyclic drill having fields '<STRONG>Country</STRONG>' and '<STRONG>Nil</STRONG>' where nil is blank.</P><P>If I select '<STRONG>Nil</STRONG>' in first cyclic drill then it should show top <STRONG>brands</STRONG> of all <STRONG>countries</STRONG> as shown in fig 1</P><P>And if I select '<STRONG>Country</STRONG> ' in cyclic drill then it have to show country wise top brands.&nbsp; ex. As shown in Fig 2 in USA there are five top brands A,B,C,D,E</P><P></P><P>Regards,</P><P>Ashish</P></BODY></HTML> Fri, 23 Oct 2015 11:23:33 GMT 2015-10-23T11:23:33Z How to use Rank function to show top brands? https://community.qlik.com/t5/QlikView/How-to-use-Rank-function-to-show-top-brands/m-p/951256#M327186 <HTML><HEAD></HEAD><BODY><P>Hello Friends,</P><P>Can any one tell me how to use Rank function in dimension of pivot table to show top Brands.</P><P>As shown in attached screen shot in first column there is a cyclic drill having fields '<STRONG>Country</STRONG>' and '<STRONG>Nil</STRONG>' where nil is blank.</P><P>If I select '<STRONG>Nil</STRONG>' in first cyclic drill then it should show top <STRONG>brands</STRONG> of all <STRONG>countries</STRONG> as shown in fig 1</P><P>And if I select '<STRONG>Country</STRONG> ' in cyclic drill then it have to show country wise top brands.&nbsp; ex. As shown in Fig 2 in USA there are five top brands A,B,C,D,E</P><P></P><P>Regards,</P><P>Ashish</P></BODY></HTML> Fri, 23 Oct 2015 11:23:33 GMT https://community.qlik.com/t5/QlikView/How-to-use-Rank-function-to-show-top-brands/m-p/951256#M327186 2015-10-23T11:23:33Z