topic Re: Creating Ranks in script editor using Auto number for tied values and then skipping the next ran in QlikView

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

DKK — Sat, 16 Nov 2024 20:05:27 GMT

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.

Regards

Kiran

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

Arthur_Fong — Fri, 13 Sep 2019 04:01:03 GMT

There you go:

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

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

DKK — Tue, 17 Sep 2019 18:40:37 GMT

Hi Arthur,

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

Regards