Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
devarasu07
Honored Contributor 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
MVP
MVP

Re: PercentRank function in qlik?

You could try like:


 

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


Capture.JPG

3 Replies
MVP
MVP

Re: PercentRank function in qlik?

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

MVP
MVP

Re: PercentRank function in qlik?

You could try like:


 

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


Capture.JPG

vinieme12
Esteemed Contributor II

Re: PercentRank function in qlik?

Hi,

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

PercentRank_.PNG