using the rank function

[#1]

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).

Please advise

[Anonymous]

Tente isso:

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

[#3]

Can you please translate to English?

[Anonymous]

Try this:

= RANK (SUM (your function), 4)

[#5]

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?

[Anonymous]

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

[#7]

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)))))
))