Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
alexmanzoni
Creator
Creator

rank() function

Hi guys,

How does it work the rank() function?

Thank you all

Regards,

Alex Manzoni

1 Solution

Accepted Solutions
alexmanzoni
Creator
Creator
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)

alexmanzoni
Creator
Creator
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.

alexmanzoni
Creator
Creator
Author

I don't have a specific example

maleksafa
Specialist
Specialist

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