Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Rank() function in Load Script

Hello,

I Need to Rank the Customers according to their Sales per year.

How could I achieve this in the load script?

 

I Need to do it in the load script because I have to do several calculations based on it.

There is no rank() function unfortunately in the load script .

Could you please help me?

Thank you!

 

Labels (2)
1 Reply
Highlighted
Champion III
Champion III

Re: Rank() function in Load Script

You can do this by resident load order by desc on dimension field. Like check here

https://community.qlik.com/t5/New-to-QlikView/Rank-Function-in-load-script/td-p/348849