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: 
rupaliqlik
Creator
Creator

Rank should not change on selection

Dear All ,

I have Person wise data and their ranks, but when I elect any person rank is showing 1 . and I want their actual rank. Please tell me what I should do in this scenario.

Thanks in advance.

12 Replies
Anonymous
Not applicable

please prepare an example...

ziadm
Specialist
Specialist

What is the expression .. ?

you need to ignore the dimension in the Rank expression

rupaliqlik
Creator
Creator
Author

Dear Robin,

I have data like this

A:

load * Inline

[

NAME, Marks

Rupali, 100

Smita, 90

John, 70

Aditi, 60

Prachi,  50

Priya, 40

Rina, 20

Mehul, 10

Disha, 15

Isha, 35

];

RANK Expression: =rank(sum(Marks))

while selection rank shows 1 .

Please suggest .

rupaliqlik
Creator
Creator
Author

Dear Robin,

I have data like this

A:

load * Inline

[

NAME, Marks

Rupali, 100

Smita, 90

John, 70

Aditi, 60

Prachi,  50

Priya, 40

Rina, 20

Mehul, 10

Disha, 15

Isha, 35

];

RANK Expression: =rank(sum(Marks))

while selection rank shows 1 .

Please suggest .

Anonymous
Not applicable

dimension NAME

expression:

if(not isnull(Marks),rank(Sum({1} Marks)))

ziadm
Specialist
Specialist

aggr(rank(sum( {1<NAME=>}  Sales)),NAME)

ziadm
Specialist
Specialist

aggr(rank(sum( {1<NAME=>}  Marks)),NAME)

rupaliqlik
Creator
Creator
Author

thanks @ !

rupaliqlik
Creator
Creator
Author

Thanks.