topic Re: Rank in Load Script in QlikView https://community.qlik.com/t5/QlikView/Rank-in-Load-Script/m-p/1274889#M852084 <HTML><HEAD></HEAD><BODY><P>So, you would like to see 1-2, and 2-2 as rank from back end scripting also?</P></BODY></HTML> Wed, 21 Mar 2018 10:19:26 GMT sunny_talwar 2018-03-21T10:19:26Z Rank in Load Script https://community.qlik.com/t5/QlikView/Rank-in-Load-Script/m-p/1274887#M852082 <HTML><HEAD></HEAD><BODY><P>Hi Geeks,</P><P></P><P>I have been working so long in assigning the rank to one of my column at the modeling level. I have tried the following expression in the straight table and is working perfectly but I want to implement the same in the Backend.</P><P></P><P>Expression: =aggr(rank(UpTime,4),Hrs,DATE,UpTime,HostName)</P><P></P><P>please find the below straight table</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>DATE</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Hrs</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">HostName</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">UpTime</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Rank</TH></TR><TR><TD style="padding: 2px;">27-02-2017</TD><TD style="padding: 2px;">00</TD><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">0.98</TD><TD style="padding: 2px;">2</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">27-02-2017</SPAN></TD><TD style="padding: 2px;">00</TD><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">1-2</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">27-02-2017</SPAN></TD><TD style="padding: 2px;">00</TD><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">1-2</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">27-02-2017</SPAN></TD><TD style="padding: 2px;">00</TD><TD style="padding: 2px;">D</TD><TD style="padding: 2px;">0.97</TD><TD style="padding: 2px;">3</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">27-02-2017</SPAN></TD><TD style="padding: 2px;">01</TD><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">0.98</TD><TD style="padding: 2px;">2-2</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">27-02-2017</SPAN></TD><TD style="padding: 2px;">01</TD><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">1</TD></TR><TR><TD><SPAN style="font-size: 13.3333px;">27-02-2017</SPAN></TD><TD>01</TD><TD>C</TD><TD>0.98</TD><TD>2-2</TD></TR><TR><TD><SPAN style="font-size: 13.3333px;">27-02-2017</SPAN></TD><TD>02</TD><TD>A</TD><TD>0.97</TD><TD>2</TD></TR><TR><TD><SPAN style="font-size: 13.3333px;">27-02-2017</SPAN></TD><TD>02</TD><TD>B</TD><TD>0.98</TD><TD>1</TD></TR></TBODY></TABLE><P></P><P>Kindly help me with the Logic how this can be implemented.</P><P></P><P>Thanks.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Rank-in-Load-Script/m-p/1274887#M852082 2020-11-25T16:16:04Z Re: Rank in Load Script https://community.qlik.com/t5/QlikView/Rank-in-Load-Script/m-p/1274888#M852083 <HTML><HEAD></HEAD><BODY><P>hi</P><P>Try this expression:</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">aggr((rank(UpTime,4),Hrs,DATE,UpTime,HostName),0,1)</P></BODY></HTML> Wed, 21 Mar 2018 10:16:29 GMT https://community.qlik.com/t5/QlikView/Rank-in-Load-Script/m-p/1274888#M852083 Anonymous 2018-03-21T10:16:29Z Re: Rank in Load Script https://community.qlik.com/t5/QlikView/Rank-in-Load-Script/m-p/1274889#M852084 <HTML><HEAD></HEAD><BODY><P>So, you would like to see 1-2, and 2-2 as rank from back end scripting also?</P></BODY></HTML> Wed, 21 Mar 2018 10:19:26 GMT https://community.qlik.com/t5/QlikView/Rank-in-Load-Script/m-p/1274889#M852084 sunny_talwar 2018-03-21T10:19:26Z