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: 
Anonymous
Not applicable

rank() function

Hi guys,

How does it work the rank() function?

Thank you all

Regards,

Alex Manzoni

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Thank you Malek, but i saw the rank() function in this way: rank(TOTAL....)
How does TOTAL do?

Thank you

View solution in original post

5 Replies
maleksafa
Specialist
Specialist

works with aggregation functions inside of it. for example if you have sum(sales) and you want to see the rank for each result, you will do rank(sum(sales)) and it will return for each dimension the rank based on the expression of sum(sales)

Anonymous
Not applicable
Author

Thank you Malek, but i saw the rank() function in this way: rank(TOTAL....)
How does TOTAL do?

Thank you

maleksafa
Specialist
Specialist

it depends how is it used, in which context.

if you have an example we can elaborate.

Anonymous
Not applicable
Author

I don't have a specific example

maleksafa
Specialist
Specialist

this is an example on how to use the rank function.