PercentRank function in qlik?

[devarasu07]

Hi All,

How to calculate PercentRank  function in qlik ? kindly advise if you have any solution. many thanks

ref:

https://community.qlik.com/t5/QlikView-App-Development/PERCENTRANK/td-p/450796

Best Regards,

Deva

[tresesco]

Recently I was working on a similar request here :Excel Rank   Check if that helps.

[tresesco · Accepted solution]

You could try like:

---

(NoOfRows(TOTAL)-RowNo(TOTAL))
/
(NoOfRows(TOTAL)-1)

---

[vinieme12]

Hi,

Attached app demonstrates working of both PercentRank and PercenrTank.EXC functions