https://community.qlik.com/t5/QlikView/Rank-function-in-Load-Script/m-p/1547021#M598660 <P>Hello,</P><P>I Need to Rank the Customers according to their Sales per year.</P><P>How could I achieve this in the load script?</P><P>&nbsp;</P><P>I Need to do it in the load script because I have to do several calculations based on it.</P><P>There is no rank() function unfortunately in the load script .</P><P>Could you please help me?</P><P>Thank you!</P><P>&nbsp;</P> Sat, 16 Nov 2024 04:23:15 GMT sabmaldun 2024-11-16T04:23:15Z https://community.qlik.com/t5/QlikView/Rank-function-in-Load-Script/m-p/1547021#M598660 <P>Hello,</P><P>I Need to Rank the Customers according to their Sales per year.</P><P>How could I achieve this in the load script?</P><P>&nbsp;</P><P>I Need to do it in the load script because I have to do several calculations based on it.</P><P>There is no rank() function unfortunately in the load script .</P><P>Could you please help me?</P><P>Thank you!</P><P>&nbsp;</P> Sat, 16 Nov 2024 04:23:15 GMT https://community.qlik.com/t5/QlikView/Rank-function-in-Load-Script/m-p/1547021#M598660 sabmaldun 2024-11-16T04:23:15Z https://community.qlik.com/t5/QlikView/Rank-function-in-Load-Script/m-p/1547034#M598661 You can do this by resident load order by desc on dimension field. Like check here<BR /><BR /><A href="https://community.qlik.com/t5/New-to-QlikView/Rank-Function-in-load-script/td-p/348849" target="_blank">https://community.qlik.com/t5/New-to-QlikView/Rank-Function-in-load-script/td-p/348849</A> Wed, 20 Feb 2019 16:58:08 GMT https://community.qlik.com/t5/QlikView/Rank-function-in-Load-Script/m-p/1547034#M598661 vishsaggi 2019-02-20T16:58:08Z