Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
marjan_it
Creator III
Creator III

Rank function for repeated data

Hi All

I have a problem in Rank function.

my data i like this :

 

   

codeNumberName
171251.11A
130650.00B
50450.00C
170248.10D
120647.83E
180147.37F
50546.88G
151746.43H
121246.39I
52143.75J

I want to show top 10 Name in text object in sort I use this

=Aggr(if(   rank(sum(Number))=1  ,Name),Code)

It is work for non repeated data but for repeated data its not work. what should I do to show data.

qvw file is attached .

1 Solution

Accepted Solutions
marjan_it
Creator III
Creator III
Author

I found It, the correct answer is that use :

=Aggr(if(  rank(sum(Number),4,0)=2  ,Name),Code)

View solution in original post

9 Replies
Anil_Babu_Samineni

Is This you are expecting

Rank.PNG

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
marjan_it
Creator III
Creator III
Author

No, In my qvw file i explain what I expect

Anil_Babu_Samineni

I don't have license. For this what are you expectingg

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
marjan_it
Creator III
Creator III
Author

This is what show and what I need.

I use rank for 1 to 10 in text object but in 2 and 3 its not show.

Anil_Babu_Samineni

Might be this

Capture.PNG

RowNo(total) - rangesum(above(total if(num(rank(total Number,1))=above(num(rank(total Number,1))),1,0),

0,RowNo(total)))

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
marjan_it
Creator III
Creator III
Author

hmm, not actually.

I want to Show order of rank name in  text object not in chart.

for example I want to show the 2nd number name in thext object. means show B or C.

When I use this  [  Aggr(if(   rank(sum(Number))=2  ,Name),Code) ]    in text onject is show -.

marcus_sommer

Maybe this is helpful: Continuous Ranking (no missing Rank)

- Marcus

marjan_it
Creator III
Creator III
Author

I found It, the correct answer is that use :

=Aggr(if(  rank(sum(Number),4,0)=2  ,Name),Code)

sunny_talwar

Just to add another set of possibility...

=FirstSortedValue(Name, -Aggr(Sum(Number)*100000 - Ord(Name), Code))

=FirstSortedValue(Name, -Aggr(Sum(Number)*100000 - Ord(Name), Code), 2)

=FirstSortedValue(Name, -Aggr(Sum(Number)*100000 - Ord(Name), Code), 3)

=FirstSortedValue(Name, -Aggr(Sum(Number)*100000 - Ord(Name), Code), 4)

=FirstSortedValue(Name, -Aggr(Sum(Number)*100000 - Ord(Name), Code), 5)

=FirstSortedValue(Name, -Aggr(Sum(Number)*100000 - Ord(Name), Code), 6)