topic Re: using the rank function in QlikView

using the rank function

Mon, 27 Jun 2011 17:53:10 GMT

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

using the rank function

Anonymous — Mon, 27 Jun 2011 18:10:15 GMT

Tente isso:

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

using the rank function

Mon, 27 Jun 2011 18:22:56 GMT

Can you please translate to English?

using the rank function

Anonymous — Mon, 27 Jun 2011 18:28:48 GMT

Try this:

= RANK (SUM (your function), 4)

using the rank function

Mon, 27 Jun 2011 18:42:45 GMT

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

Anonymous — Mon, 27 Jun 2011 19:03:27 GMT

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

Re: using the rank function

Wed, 10 Jun 2015 09:30:42 GMT

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