topic Rank within Group in QlikView https://community.qlik.com/t5/QlikView/Rank-within-Group/m-p/1238851#M393705 <HTML><HEAD></HEAD><BODY><P>Hello </P><P>I am trying use Rank to get the rank for the User.</P><P></P><P>In the following data, <SPAN style="font-size: 13.3333px;">if a user selected UserID = 2 then </SPAN>ranking based on Score; </P><P>I need to show 2 rows</P><P>- first for Study ID 1 with rank 2 </P><P>- and second for Study ID 2 with rank 1.</P><P></P><P>How do I accomplish that?</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="295"><TBODY><TR><TD height="20" width="51">User ID</TD><TD width="74">First Name</TD><TD width="71">Last Name</TD><TD width="58">Study ID</TD><TD width="41">Score</TD></TR><TR><TD align="right" height="20">1</TD><TD>a</TD><TD>b</TD><TD align="right">1</TD><TD align="right">4</TD></TR><TR><TD align="right" height="20">2</TD><TD>c</TD><TD>d</TD><TD align="right">1</TD><TD align="right">2</TD></TR><TR><TD align="right" height="20">3</TD><TD>e</TD><TD>f</TD><TD align="right">1</TD><TD align="right">1</TD></TR><TR><TD align="right" height="20">1</TD><TD>a</TD><TD>b</TD><TD align="right">2</TD><TD align="right">2</TD></TR><TR><TD align="right" height="20">2</TD><TD>c</TD><TD>d</TD><TD align="right">2</TD><TD align="right">4</TD></TR><TR><TD align="right" height="20">3</TD><TD>e</TD><TD>f</TD><TD align="right">2</TD><TD align="right">2</TD></TR></TBODY></TABLE><P></P><P>Thanks</P></BODY></HTML> Wed, 08 Feb 2017 21:35:50 GMT 2017-02-08T21:35:50Z Rank within Group https://community.qlik.com/t5/QlikView/Rank-within-Group/m-p/1238851#M393705 <HTML><HEAD></HEAD><BODY><P>Hello </P><P>I am trying use Rank to get the rank for the User.</P><P></P><P>In the following data, <SPAN style="font-size: 13.3333px;">if a user selected UserID = 2 then </SPAN>ranking based on Score; </P><P>I need to show 2 rows</P><P>- first for Study ID 1 with rank 2 </P><P>- and second for Study ID 2 with rank 1.</P><P></P><P>How do I accomplish that?</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="295"><TBODY><TR><TD height="20" width="51">User ID</TD><TD width="74">First Name</TD><TD width="71">Last Name</TD><TD width="58">Study ID</TD><TD width="41">Score</TD></TR><TR><TD align="right" height="20">1</TD><TD>a</TD><TD>b</TD><TD align="right">1</TD><TD align="right">4</TD></TR><TR><TD align="right" height="20">2</TD><TD>c</TD><TD>d</TD><TD align="right">1</TD><TD align="right">2</TD></TR><TR><TD align="right" height="20">3</TD><TD>e</TD><TD>f</TD><TD align="right">1</TD><TD align="right">1</TD></TR><TR><TD align="right" height="20">1</TD><TD>a</TD><TD>b</TD><TD align="right">2</TD><TD align="right">2</TD></TR><TR><TD align="right" height="20">2</TD><TD>c</TD><TD>d</TD><TD align="right">2</TD><TD align="right">4</TD></TR><TR><TD align="right" height="20">3</TD><TD>e</TD><TD>f</TD><TD align="right">2</TD><TD align="right">2</TD></TR></TBODY></TABLE><P></P><P>Thanks</P></BODY></HTML> Wed, 08 Feb 2017 21:35:50 GMT https://community.qlik.com/t5/QlikView/Rank-within-Group/m-p/1238851#M393705 2017-02-08T21:35:50Z Re: Rank within Group https://community.qlik.com/t5/QlikView/Rank-within-Group/m-p/1238852#M393706 <HTML><HEAD></HEAD><BODY><P>Maybe create a straight table chart with 1 dimension and 1 expression</P><P></P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR bgcolor="#f5f5f5"><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Study ID</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>=Only(Aggr(Rank(Only({1}Score)), [Study ID], [User ID]))</STRONG></SPAN><STRONG> </STRONG></TH></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1</SPAN></TD></TR></TBODY></TABLE></BODY></HTML> Wed, 08 Feb 2017 22:08:57 GMT https://community.qlik.com/t5/QlikView/Rank-within-Group/m-p/1238852#M393706 swuehl 2017-02-08T22:08:57Z Re: Rank within Group https://community.qlik.com/t5/QlikView/Rank-within-Group/m-p/1238853#M393707 <HTML><HEAD></HEAD><BODY><P>Thanks Stefan</P></BODY></HTML> Thu, 09 Feb 2017 14:13:21 GMT https://community.qlik.com/t5/QlikView/Rank-within-Group/m-p/1238853#M393707 2017-02-09T14:13:21Z