Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You could try like:
(NoOfRows(TOTAL)-RowNo(TOTAL))
/
(NoOfRows(TOTAL)-1)
Recently I was working on a similar request here :Excel Rank Check if that helps.
You could try like:
(NoOfRows(TOTAL)-RowNo(TOTAL))
/
(NoOfRows(TOTAL)-1)
Hi,
Attached app demonstrates working of both PercentRank and PercenrTank.EXC functions