Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I am not able to rank based on the column in the pivot table. I have a pivot table as follows
Candidate Names | English | Hindi | Maths | Science | Social | |
---|---|---|---|---|---|---|
Candidate 1 | 50 | 20 | 10 | 10 | 20 | |
| 90 | 100 | 80 | 60 | 30 | |
Candiate 3 | 45 | 67 | 98 | 79 | 50 | |
Candidate 4 | 50 | 50 | 30 | 30 | 20 |
Now, I have to give rank based on the subject marks secured by the candidate. The output should be as follows
Candidate Names | English | Hindi | Maths | Science | Social | |
---|---|---|---|---|---|---|
Candidate 1 | 1 | 2 | 3 | 3 | 2 | |
| 2 | 1 | 3 | 4 | 5 | |
Candiate 3 | 5 | 3 | 1 | 2 | 4 | |
Candidate 4 | 1 | 1 | 2 | 2 | 3 |
How can I achieve this in Qlik Sense expressions? I could not done this by using RANK function?
Please help me out. I appreciate the quick solution . Thanks in advance
Thanks you very much for your quick response Sai. I have derived the required function from the link which you shared.
The expression is like this
AGGR(Rank(sum(marks),1), [SubjectNames])
Thanks once again sai.
Thanks much for your feedback Narendra Kumar!!
Could you please mark the answer and also close the thread.
Regards
Sai.