topic Re: Ranking in script in QlikView https://community.qlik.com/t5/QlikView/Ranking-in-script/m-p/743559#M665092 <HTML><HEAD></HEAD><BODY><P>with an order by ?</P><P></P><P>a:</P><P>load * inline [</P><P>Customer,&nbsp;&nbsp;&nbsp;&nbsp; Sales,&nbsp;&nbsp;&nbsp;&nbsp; Rank</P><P>ABC&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000 ,&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P>DEF&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1200,&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>XYZ&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 900 ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3</P><P>];</P><P></P><P>b:</P><P>load *, <STRONG>rowno() as newrank</STRONG></P><P>Resident a</P><P><STRONG>order by Sales desc;</STRONG></P></BODY></HTML> Wed, 21 Jan 2015 18:33:06 GMT maxgro 2015-01-21T18:33:06Z Ranking in script https://community.qlik.com/t5/QlikView/Ranking-in-script/m-p/743557#M665086 <HTML><HEAD></HEAD><BODY><P>Does anyone have an example of ranking a list (example Customer, Sales), in the <STRONG style="text-decoration: underline;">script</STRONG>?</P><P></P><P>EG</P><P><SPAN style="text-decoration: underline;">Customer&nbsp;&nbsp;&nbsp;&nbsp; Sales&nbsp;&nbsp;&nbsp;&nbsp; Rank</SPAN></P><P>ABC&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P>DEF&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1200&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>XYZ&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 900&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3</P><P></P><P>Regards</P><P>Marty.</P></BODY></HTML> Wed, 21 Jan 2015 18:21:07 GMT https://community.qlik.com/t5/QlikView/Ranking-in-script/m-p/743557#M665086 martynlloyd 2015-01-21T18:21:07Z Re: Ranking in script https://community.qlik.com/t5/QlikView/Ranking-in-script/m-p/743558#M665087 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P></P><P>Yes you can do in load script with Autonumber and order it desc by sales</P><P></P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_14218650020336604" jivemacro_uid="_14218650020336604" modifiedtitle="true"> <P>Data:</P> <P>LOAD * INLINE [</P> <P>&nbsp;&nbsp;&nbsp; Customer, Sales</P> <P>&nbsp;&nbsp;&nbsp; ABC, 1000</P> <P>&nbsp;&nbsp;&nbsp; DEF, 1200</P> <P>&nbsp;&nbsp;&nbsp; XYZ, 900</P> <P>&nbsp;&nbsp;&nbsp; eeee, 2300</P> <P>];</P> <P></P> <P>NoConcatenate</P> <P>FinalTable:</P> <P>LOAD</P> <P>Customer, Sales,AutoNumber(Sales) as RankNew Resident Data Order By Sales desc;</P> <P></P> <P>DROP Table Data;</P> </PRE><P></P><P><IMG __jive_id="75850" alt="Rank in Script.png" class="image-1 jive-image" src="/legacyfs/online/75850_Rank in Script.png" style="height: auto;" /></P><P></P><P>Regards</P><P>Anand</P></BODY></HTML> Wed, 21 Jan 2015 18:30:30 GMT https://community.qlik.com/t5/QlikView/Ranking-in-script/m-p/743558#M665087 its_anandrjs 2015-01-21T18:30:30Z Re: Ranking in script https://community.qlik.com/t5/QlikView/Ranking-in-script/m-p/743559#M665092 <HTML><HEAD></HEAD><BODY><P>with an order by ?</P><P></P><P>a:</P><P>load * inline [</P><P>Customer,&nbsp;&nbsp;&nbsp;&nbsp; Sales,&nbsp;&nbsp;&nbsp;&nbsp; Rank</P><P>ABC&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000 ,&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P>DEF&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1200,&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>XYZ&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 900 ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3</P><P>];</P><P></P><P>b:</P><P>load *, <STRONG>rowno() as newrank</STRONG></P><P>Resident a</P><P><STRONG>order by Sales desc;</STRONG></P></BODY></HTML> Wed, 21 Jan 2015 18:33:06 GMT https://community.qlik.com/t5/QlikView/Ranking-in-script/m-p/743559#M665092 maxgro 2015-01-21T18:33:06Z Re: Ranking in script https://community.qlik.com/t5/QlikView/Ranking-in-script/m-p/743560#M665097 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>see my example file rank.qvw.</P><P></P><P>- it contains a sub providing flexible ranking mechanisms, <BR />&nbsp; such as ranking by autonumber or by row().<BR />- ranks can be split into half ranks for identical values<BR />&nbsp; (e.g. rank 11,12,13 -&gt; 12, 12, 12)</P><P></P><P><A _jive_internal="true" href="https://community.qlik.com/docs/DOC-13949">https://community.qlik.com/docs/DOC-13949</A></P><P></P><P>Regards - Marcel</P></BODY></HTML> Sun, 15 Nov 2015 11:13:11 GMT https://community.qlik.com/t5/QlikView/Ranking-in-script/m-p/743560#M665097 hugmarcel 2015-11-15T11:13:11Z