Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
devarasu07
Master II
Master II

PercentRank function in qlik?

Hi All,

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

Capture.JPG

ref:

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

 

Best Regards,

Deva

Labels (1)
1 Solution

Accepted Solutions
tresesco
MVP
MVP

You could try like:


 

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


Capture.JPG

View solution in original post

3 Replies
tresesco
MVP
MVP

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

tresesco
MVP
MVP

You could try like:


 

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


Capture.JPG

View solution in original post

vinieme12
Champion II
Champion II

Hi,

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

PercentRank_.PNG