Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
BootCam
Creator
Creator

How to calculate Percentile based on Excel Percentile Rank function

Hi,

 

Can Anyone help me with percentile calculation based on the attach file? I just dont know how to use the PercentileRank.EXC function in qlikview to reach the desired percentage numbers in Qlikview.

 

The calculations are made in Excel but need a bit help to translate that into Qlikview.

 

Thanks,

 

Labels (2)
10 Replies
BootCam
Creator
Creator
Author

Hi Vinieme12,

Thank you so much for your solution.

Best,

BC