Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2013-02-19 03:44 PM

Percentile Reverse

How would qlikiview duplicate excels Function PErcentileRank =PERCENTRANK(B2:B8,13) = 50%

I know howe to get the Percentile from the fractile function. Is there a way to get the PercentRank the way excel calculates this? 

IDValuePercentILE Excel Rank
719
6150.5
514
413
312
29
18
1,762 Views
0 Likes
0 Replies