topic Re: Qlik Fractile vs Excel Percentile in App Development

Qlik Fractile vs Excel Percentile

edwardgoss — Thu, 23 Nov 2023 17:22:02 GMT

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!

Re: Qlik Fractile vs Excel Percentile

rwunderlich — Thu, 23 Nov 2023 18:11:07 GMT

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

Re: Qlik Fractile vs Excel Percentile

edwardgoss — Thu, 23 Nov 2023 21:01:05 GMT

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

Re: Qlik Fractile vs Excel Percentile

edwardgoss — Wed, 29 Nov 2023 13:07:47 GMT

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.