Qlik Fractile vs Excel Percentile

[edwardgoss]

I need to calculate the 50th and 90th percentile in Qlik the way Excel does it. The Qlik Fractile function ONLY returns a value in the list of numbers, while Excel returns an inferred number. See example below. Does anyone know how I can return the Excel based value?

In this example, the P50 returns the same value for both, but the P90 does not. Thanks in advance!

[rwunderlich]

Using your data in Qlik, I get 150.2 for Fractile(Days, .9)

[edwardgoss]

I have an if statement in the fractile all embedded in an aggr function.  I must have something wrong. Thank you. 

[edwardgoss]

Hi Rob,

The issue was with the data not having unique values. I reran the script using 'Distinct' and the percentile function is working as expected.