Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
DKK
Contributor III
Contributor III

Creating Ranks in script for tied values and then skipping the next rank by Autonumber

Hi All

I was trying to creating the ranks  for the following data as follows but some how its not giving the right results by using Autonumber function. output required for ranks should be something like ( 1,2,2,4,5,6,6,8)  and attached is the excel file for reference. Any advise or help is highly appreciated

 

Regards

KD

Labels (2)
2 Replies
sugathirajkumar
Creator
Creator

rank(sum(Amount))

clipboard_image_0.png

DKK
Contributor III
Contributor III
Author

Hi,

i don’t think we can use Rank() function in the script . Moreover my desired rank should be something liken1,2,2,4