Calculation for percentile of a value

[snancyiv]

Hello,

 I’m trying to calculate what percentile a value is. If I have a KPI chart that shows the percent of sales as 38%, the percentile would be the 25th percentile. Is this possible?

[justISO]

Hi, you can try to use fractile() function, something like this maybe:

if( sales <= Fractile(total sales, 0.25), 25,
if( sales <= Fractile(total sales, 0.5), 50,
if( sales <= Fractile(total sales, 0.75), 75, 100)))

[snancyiv]

Hi,

thanks but that’s not what I’m looking for. I suppose this topic is closest to what I mean but I need it in a KPI chart view: https://community.qlik.com/t5/QlikView-App-Dev/Calculate-percentile-of-specific-value/td-p/1008421