6 Replies Latest reply: Jun 10, 2015 5:30 AM by L H

# using the rank function

To whom it may concern:

I am trying to rank 12 numbers, however, some of the numbers are the same.   Qlikview is creating a single rank value for multiple occurrences of the raw data.  But I need it to rank all 12 numbers and display all 12 numbers.  I have included an excel file also of how I would like the data to look (the yellow high-lighted area).

• ###### using the rank function

Tente isso:

=RANK(SUM(sua função),4)

• ###### using the rank function

Can you please translate to English?

• ###### using the rank function

Try this:

= RANK (SUM (your function), 4)

• ###### using the rank function

Sorry,

so I am doing a "rank(Sum(Varname),4)" ... and now the ranks are out of order and I don't get the total number of records.  What am I doing wrong?

• ###### using the rank function

Set the expression that has the formula in the first rank position in the tab classification.

• ###### Re: using the rank function

washington Can I also use rank with a formula?

Like this?

= RANK (SUM (sum({<year={"\$(=MAX(year))"}>}
(
If(time<= Per,
If(ex3>= 4560,
If(ex3<= 9080,
((
[ex1])/100)-(([ex2])/100)
,0)))))
))