Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
sabmaldun
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 (1)
1 Reply
vishsaggi
Champion III
Champion III

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