topic Re: Rank function on the PIVOT column in Qlik sense in App Development

Rank function on the PIVOT column in Qlik sense

Thu, 07 Jan 2016 06:48:33 GMT

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

Candidate 2

100

Candiate 3

Candidate 4

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

Candidate 2

Candiate 3

Candidate 4

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

Thu, 07 Jan 2016 08:54:01 GMT

This might help

Thu, 07 Jan 2016 15:58:28 GMT

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.

Fri, 08 Jan 2016 04:54:06 GMT

Thanks much for your feedback Narendra Kumar!!

Could you please mark the answer and also close the thread.

Regards

Sai.