What does the Rank() function do?

Tue, 24 Jun 2014 15:43:35 GMT

Hi all,

I am trying to understand what the rank function does but I am not entirely sure how it works.

Does anyone have a simple illustrated example of how it works and what it returns?

Reading the Help in QlikView it seems that the function returns the position of a value in a given table. I tried testing it but I couldn't get it to work to confirm my understanding.

Any help would be great

Re: What does the Rank() function do?

richard_chilvers — Tue, 24 Jun 2014 16:08:30 GMT

The rank function will identify the place a row has in a table based on the field you specify.

I have a current example of a call centre where we rank each member in the team according to the value of the sales they make in a month.

By making the rank the primary sort field we get:

Rank Name Sales

1 Richard Jones £200,000

2 Richard Smith £180,000

3 Richard Name £150,000

This is a simple example where the rank expression is simply RANK(Sales).

Hope this isn't too simple and helps.

Regards

topic What does the Rank() function do? in QlikView

What does the Rank() function do?

Re: What does the Rank() function do?