Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

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
Highlighted
Partner
Partner

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

Highlighted
Contributor III
Contributor III

Hi Arthur,

 

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

 

Regards

KD