topic Re: ranking in QlikView https://community.qlik.com/t5/QlikView/ranking/m-p/284190#M1177805 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Here i attached the same file with bar chart</P><P></P><P>Regards</P><P>Ashok</P></BODY></HTML> Wed, 15 Feb 2012 12:16:14 GMT Anonymous 2012-02-15T12:16:14Z ranking https://community.qlik.com/t5/QlikView/ranking/m-p/284188#M1177803 <HTML><HEAD></HEAD><BODY><P>hi </P><P></P><P>i am trying to create a bar chart showing the top 5 countries with highest inflation rate.</P><P>i have three list boxes with details of country,capital and inflation rate.</P><P></P><P>what expression must be used??</P><P>explain the syntax in detail??</P></BODY></HTML> Wed, 15 Feb 2012 11:58:37 GMT https://community.qlik.com/t5/QlikView/ranking/m-p/284188#M1177803 2012-02-15T11:58:37Z Re: ranking https://community.qlik.com/t5/QlikView/ranking/m-p/284189#M1177804 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; the attached file will be use for your requirement</P><P></P><P></P><P>Regards</P><P></P><P>Ashok</P></BODY></HTML> Wed, 15 Feb 2012 12:12:39 GMT https://community.qlik.com/t5/QlikView/ranking/m-p/284189#M1177804 Anonymous 2012-02-15T12:12:39Z Re: ranking https://community.qlik.com/t5/QlikView/ranking/m-p/284190#M1177805 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Here i attached the same file with bar chart</P><P></P><P>Regards</P><P>Ashok</P></BODY></HTML> Wed, 15 Feb 2012 12:16:14 GMT https://community.qlik.com/t5/QlikView/ranking/m-p/284190#M1177805 Anonymous 2012-02-15T12:16:14Z Re: ranking https://community.qlik.com/t5/QlikView/ranking/m-p/284191#M1177806 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; You can use this expression</P><P> =Sum({&lt;Country={"=Rank(Sum(InflationRate))&lt;6"}&gt;} InflationRate)</P><P></P><P>Celambarasan</P></BODY></HTML> Wed, 15 Feb 2012 12:23:45 GMT https://community.qlik.com/t5/QlikView/ranking/m-p/284191#M1177806 CELAMBARASAN 2012-02-15T12:23:45Z ranking https://community.qlik.com/t5/QlikView/ranking/m-p/284192#M1177807 <HTML><HEAD></HEAD><BODY><P> is there any book or something like that from where i can learn the syntax of writing the expressions??</P></BODY></HTML> Thu, 16 Feb 2012 10:21:39 GMT https://community.qlik.com/t5/QlikView/ranking/m-p/284192#M1177807 2012-02-16T10:21:39Z Re: ranking https://community.qlik.com/t5/QlikView/ranking/m-p/284193#M1177808 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; For set analysis you can use the attached material it will be usefull.</P><P></P><P>Celambarasan</P></BODY></HTML> Thu, 16 Feb 2012 10:28:56 GMT https://community.qlik.com/t5/QlikView/ranking/m-p/284193#M1177808 CELAMBARASAN 2012-02-16T10:28:56Z