topic Re: Rank function within FieldValue in QlikView https://community.qlik.com/t5/QlikView/Rank-function-within-FieldValue/m-p/1347740#M414619 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>See Attachment.</P><P>Regards,</P><P>Antonio</P></BODY></HTML> Sat, 10 Jun 2017 06:09:03 GMT antoniotiman 2017-06-10T06:09:03Z Rank function within FieldValue https://community.qlik.com/t5/QlikView/Rank-function-within-FieldValue/m-p/1347739#M414618 <HTML><HEAD></HEAD><BODY><P>Hi Qlikees,</P><P></P><P>How can I find 1st 3 positions of each customer in customer column by Sales.</P><P></P><P>Example</P><P></P><TABLE border="1" class="jiveBorder" height="525.011364" style="border: 1px solid rgb(0, 0, 0); width: 213.011px; height: 528.011px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Person</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Sales</TH></TR><TR><TD style="padding: 2px;"><P>A</P></TD><TD style="padding: 2px;">100</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">547</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">541</TD></TR><TR><TD style="padding: 2px;">D</TD><TD style="padding: 2px;">624</TD></TR><TR><TD style="padding: 2px;">E</TD><TD style="padding: 2px;">547</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">214</TD></TR><TR><TD style="padding: 2px;"><P><SPAN style="font-size: 10pt;">A</SPAN></P></TD><TD style="padding: 2px;">569</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">547</TD></TR><TR><TD style="padding: 2px;">D</TD><TD style="padding: 2px;">214</TD></TR><TR><TD style="padding: 2px;">D</TD><TD style="padding: 2px;">632</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">845</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">624</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">854</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">124</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">365</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">215</TD></TR><TR><TD style="padding: 2px;">D</TD><TD style="padding: 2px;">847</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">621</TD></TR><TR><TD style="padding: 2px;">D</TD><TD style="padding: 2px;">321</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">874</TD></TR></TBODY></TABLE><P></P><P>Output: Display top 3 by each same person also is there a way to choose topers seperately like only list of 2nd / 3rd / 1st.</P><P></P><TABLE border="1" class="jiveBorder" height="273.011364" style="border: 1px solid rgb(0, 0, 0); width: 212.011px; height: 276.011px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Person</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Sales</STRONG></TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">845</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">624</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">569</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">854</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">547</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">365</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">874</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">621</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">547</TD></TR><TR><TD style="padding: 2px;">D</TD><TD style="padding: 2px;">847</TD></TR><TR><TD>D</TD><TD>632</TD></TR><TR><TD>D</TD><TD>624</TD></TR></TBODY></TABLE><P></P><P>Your help much appreciated in community.</P><P></P><P>Regards</P><P>Taj Mohamed</P></BODY></HTML> Sat, 10 Jun 2017 05:36:00 GMT https://community.qlik.com/t5/QlikView/Rank-function-within-FieldValue/m-p/1347739#M414618 tajmohamed30 2017-06-10T05:36:00Z Re: Rank function within FieldValue https://community.qlik.com/t5/QlikView/Rank-function-within-FieldValue/m-p/1347740#M414619 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>See Attachment.</P><P>Regards,</P><P>Antonio</P></BODY></HTML> Sat, 10 Jun 2017 06:09:03 GMT https://community.qlik.com/t5/QlikView/Rank-function-within-FieldValue/m-p/1347740#M414619 antoniotiman 2017-06-10T06:09:03Z Re: Rank function within FieldValue https://community.qlik.com/t5/QlikView/Rank-function-within-FieldValue/m-p/1347741#M414620 <HTML><HEAD></HEAD><BODY><P>Thank you Antonio Mancini</P><P></P><P>This is what exactly I'm looking for, hence closing this dicsussion.</P><P></P><P>Regards</P><P>Taj Mohamed</P></BODY></HTML> Sat, 10 Jun 2017 08:25:29 GMT https://community.qlik.com/t5/QlikView/Rank-function-within-FieldValue/m-p/1347741#M414620 tajmohamed30 2017-06-10T08:25:29Z Re: Rank function within FieldValue https://community.qlik.com/t5/QlikView/Rank-function-within-FieldValue/m-p/1347742#M414621 <HTML><HEAD></HEAD><BODY><P>You can use simply this after generating the Key</P><P><STRONG>If(Rank(Sum(Sales)) &lt;= 3, Sum(Sales))</STRONG></P></BODY></HTML> Sun, 11 Jun 2017 05:18:31 GMT https://community.qlik.com/t5/QlikView/Rank-function-within-FieldValue/m-p/1347742#M414621 Anil_Babu_Samineni 2017-06-11T05:18:31Z