3 Replies Latest reply: Jan 7, 2016 11:54 PM by Sai Kumar RSS

    Rank function on the PIVOT column in Qlik sense

      Hi Experts,

       

         I am not able to rank based on the column in the pivot table. I have a pivot table as follows

       

      Candidate NamesEnglishHindiMathsScience

      Social

      Candidate 15020101020
      Candidate 2
      90100806030
      Candiate 34567987950
      Candidate 45050303020

       

      Now, I have to give rank based on the subject marks secured by the candidate. The output should be as follows

       

      Candidate NamesEnglishHindiMathsScience

      Social

      Candidate 112332
      Candidate 2
      21345
      Candiate 353124
      Candidate 411223

       

      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