Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Using your data in Qlik, I get 150.2 for Fractile(Days, .9)
I have an if statement in the fractile all embedded in an aggr function. I must have something wrong. Thank you.
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.