topic Rank Issue in QlikView

Rank Issue

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi all

My requirement is show student ranks based on their percentages in table when we select the student in table

it should show name and rank in another text boxes

here issue is :

before student selection rank is working fine like below

before selection Satya rank is 3

after student selection its showing as 1

but even after student selection i should see same rank(3) in table and also in text boxes

Attached APP for more details

swuehl‌stevedark‌

thank you

SRP

adamdavi3s — Thu, 09 Feb 2017 12:18:24 GMT

Try using =aggr(rank(sum({<Student -=>}Percentage)),Student)

Anonymous — Thu, 09 Feb 2017 12:25:14 GMT

Appreciate your quick help

but its not working still showing rank as 1 when i select student

adamdavi3s — Thu, 09 Feb 2017 12:28:28 GMT

Working fine here?

Anonymous — Thu, 09 Feb 2017 12:42:39 GMT

yes its working i missed aggr() function

adamdavi3s — Thu, 09 Feb 2017 12:44:58 GMT

Brill, sorry I missed it first and had to edit my answer so that was probably the issue!

Anonymous — Thu, 09 Feb 2017 12:55:23 GMT

yeah even i was in confusion whether i tried previous ans properly or not anyway thank you adam!