topic Re: Highest Rank in QlikView

Highest Rank

amars — Fri, 30 Aug 2013 06:24:36 GMT

Hi all,

While using Rank Function, I wish to find out the last rank in the row. i.e.

User Score Rank(Total Sum(Score))

abc 55 3

pqr 22 4

xyz 71 2

anz 91 1

Now I wish to find out 4 for each row of the Chart Table . i.e. desired output

User Score Rank(Total Sum(Score)) highest Rank

abc 55 3 4

pqr 22 4 4

xyz 71 2 4

anz 91 1 4

Kindly suggest how can I achieve this.

Thanks in advance

michael_maeuser — Fri, 30 Aug 2013 06:28:07 GMT

bottom(rowno())

CELAMBARASAN — Fri, 30 Aug 2013 06:28:56 GMT

Hi,

Try with this

Max(Total Aggr(Rank(Sum(Score)),User))

jjordaan — Fri, 30 Aug 2013 06:29:07 GMT

Try This Rank(-Sum(Field))

vikasmahajan — Fri, 30 Aug 2013 06:29:53 GMT

=AGGR(Rank( Total(Rank(Total Sum(Score)) , USER,SCORE)

Vikas