Qlik Community

Qlik Sense App Development

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

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
KiranD
New 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
Contributor

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

rank(sum(Amount))

clipboard_image_0.png

KiranD
New Contributor III

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

Hi,

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