Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
DKK
Contributor III
Contributor III

Creating Ranks in script editor using Auto number for tied values and then skipping the next rank

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 Auto number 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.

RankScreenshot.JPG

Regards

Kiran

Labels (6)
1 Solution

Accepted Solutions
Arthur_Fong
Partner - Specialist III
Partner - Specialist III

There you go:

clipboard_image_0.png

Split the fact table into Regions and apply rowno() to get numRow column for each regions.

Then, concatenate all Regions table into one.

Finally, use both fields to check if the autonumber Rank field is repeated using peek() function.

 

Refer qvw attached for reference.

Thanks and regards,

Arthur Fong

View solution in original post

2 Replies
Arthur_Fong
Partner - Specialist III
Partner - Specialist III

There you go:

clipboard_image_0.png

Split the fact table into Regions and apply rowno() to get numRow column for each regions.

Then, concatenate all Regions table into one.

Finally, use both fields to check if the autonumber Rank field is repeated using peek() function.

 

Refer qvw attached for reference.

Thanks and regards,

Arthur Fong

DKK
Contributor III
Contributor III
Author

Hi Arthur,

 

Thank you so much for the response and it worked like a charm.

 

Regards

KD