topic rank() function in QlikView

rank() function

Anonymous — Fri, 17 Apr 2015 13:29:31 GMT

Hi guys,

How does it work the rank() function?

Thank you all

Regards,

Alex Manzoni

Re: rank() function

maleksafa — Fri, 17 Apr 2015 13:33:32 GMT

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)

Re: rank() function

Anonymous — Fri, 17 Apr 2015 13:37:22 GMT

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

Thank you

Re: rank() function

maleksafa — Fri, 17 Apr 2015 13:39:35 GMT

it depends how is it used, in which context.

if you have an example we can elaborate.

Re: rank() function

Anonymous — Fri, 17 Apr 2015 13:42:11 GMT

I don't have a specific example

Re: rank() function

maleksafa — Fri, 17 Apr 2015 13:47:53 GMT

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