topic Help On Rank Function in QlikView https://community.qlik.com/t5/QlikView/Help-On-Rank-Function/m-p/299990#M497361 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>can any one help me regarding the following issue please:</P><P>I have a report containing the Loan and outstanding data. Below is an example</P><P><IMG alt="untitled.bmp" class="jive-image-thumbnail jive-image" onclick="" src="https://community.qlik.com/legacyfs/online/7626_untitled.bmp" width="450" /></P><P>I have to show the top 3 Customers for <STRONG>Loan </STRONG>or for <STRONG>Outstanding</STRONG>. I tried with a pivot table in qv by applying the <STRONG>Rank() Function.</STRONG> </P><P>When I tried with the following details</P><P>Dimention - Customer name </P><P>Expression- Loan, Outstanding, =Rank(Loan), the Rank function is working fine. But When I am putting all fields as Dimention(Country, Name, ID, Group and Industry) the Rank function is not working and only showing 1 all entry. (I need to show all the fields in the table)</P><P></P><P>Can you please help me, where I am going wrong.</P><P></P><P>Attached is the sample for reference.</P></BODY></HTML> Thu, 29 Sep 2011 11:43:40 GMT 2011-09-29T11:43:40Z Help On Rank Function https://community.qlik.com/t5/QlikView/Help-On-Rank-Function/m-p/299990#M497361 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>can any one help me regarding the following issue please:</P><P>I have a report containing the Loan and outstanding data. Below is an example</P><P><IMG alt="untitled.bmp" class="jive-image-thumbnail jive-image" onclick="" src="https://community.qlik.com/legacyfs/online/7626_untitled.bmp" width="450" /></P><P>I have to show the top 3 Customers for <STRONG>Loan </STRONG>or for <STRONG>Outstanding</STRONG>. I tried with a pivot table in qv by applying the <STRONG>Rank() Function.</STRONG> </P><P>When I tried with the following details</P><P>Dimention - Customer name </P><P>Expression- Loan, Outstanding, =Rank(Loan), the Rank function is working fine. But When I am putting all fields as Dimention(Country, Name, ID, Group and Industry) the Rank function is not working and only showing 1 all entry. (I need to show all the fields in the table)</P><P></P><P>Can you please help me, where I am going wrong.</P><P></P><P>Attached is the sample for reference.</P></BODY></HTML> Thu, 29 Sep 2011 11:43:40 GMT https://community.qlik.com/t5/QlikView/Help-On-Rank-Function/m-p/299990#M497361 2011-09-29T11:43:40Z