topic Re: Ranking expression in QlikView

Ranking expression

infock12 — Wed, 23 Sep 2015 12:25:26 GMT

Hello all,

I am using the following expression: The dimension is a student name.

Num(count({<Ratings={'>=7'}>} Questions)/Count(Questions), '0.00%')

When two students have the same percentages, i.e., ranked 2, Qv puts one on top of the other. I wanted to add a column to show their ranks are the same. For example,

John - 99% - 1

Jo - 98.6% - 2

Joe - 98.6% - 3

I know I may have to use rowno() and rank() function but now sure how. Any help is appreciated.

Re: Ranking expression

infock12 — Wed, 23 Sep 2015 12:29:06 GMT

Sorry friends,

I made an error in the previous post. I would like that extra ranked column to show

John - 99% - 1

Jo - 98.6% - 2

Joe - 98.6% - 2 (mentioned as 3 in the previous post)

Thanks,

Re: Ranking expression

sunny_talwar — Wed, 23 Sep 2015 12:31:41 GMT

May be try with AutoNumber()

LOAD Name,

Percentage,

AutoNumber(Percentage) as Ratings Rank

FROM Source

Re: Ranking expression

Gabriel — Wed, 23 Sep 2015 12:34:32 GMT

Hi,

Are you calculating the percentage in the script?

Re: Ranking expression

infock12 — Wed, 23 Sep 2015 12:49:32 GMT

Hi Gabriel,

No, I am calculating in the Expression tab.

Thanks,

Karthik

Re: Ranking expression

Gabriel — Wed, 23 Sep 2015 12:55:19 GMT

I will suggest you move the calculation to script.

You can then use the Peek() function and RowNo() to Rank.

Moving the calculation to Script helps the App to perform better

Please post a sample data so that community can help with solution

Re: Ranking expression

infock12 — Wed, 23 Sep 2015 13:25:01 GMT

Hi Gabriel,

Here is the attached qvw and sample data

Re: Ranking expression

CELAMBARASAN — Wed, 23 Sep 2015 13:52:10 GMT

use Rank function

Rank(COUNT({<Marks={'>=7'}>}GID)/Count(GID))

Rank(COUNT({<Marks={'>=7'}>}GID)/Count(GID), 1,1)

Re: Ranking expression

Gabriel — Wed, 23 Sep 2015 15:45:17 GMT

Hi,

I think you achieve your requirement in UI as well.

What I did is to add another calculation as below

=if(above(Num(COUNT({<Marks={'>=7'}>}GID)/Count(GID), '0.00%')) = Num(COUNT({<Marks={'>=7'}>}GID)/Count(GID), '0.00%'),RowNo(TOTAL) -1, RowNo(TOTAL))

Try it