How to write this Excel expression into qliksense chart

[whitestonek]

Dear friends,

I have one excel file with few columns. In one of the column they wrote this excel logic =PERCENTRANK.EXC($Z$4:$Z$105,Z4,1)*10+1 . I am unable to understand this how to implement in qliksense chart.

Can you please tell me this expression in qliksense.

Thank you:)

[sunny_talwar]

Would you be able to share a sample of how this is used in Excel.

[whitestonek]

Hi Sunny ,

this is my excel table.I want to do this calculation in pivot table in qliksense.

Can you please help me out.

[tresesco]

Have a look here:

 https://community.qlik.com/t5/New-to-Qlik-Sense/PercentRank-function-in-qlik/m-p/1513238#M120213

https://community.qlik.com/t5/New-to-QlikView/How-to-calculate-Percentile-based-on-Excel-Percentile-...

[sunny_talwar]

Can you attach the Excel file please?