topic Re: Calculation for percentile of a value in App Development

Calculation for percentile of a value

snancyiv — Sat, 29 Jul 2023 10:04:18 GMT

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?

Re: Calculation for percentile of a value

justISO — Mon, 31 Jul 2023 07:47:00 GMT

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)))

Re: Calculation for percentile of a value

snancyiv — Mon, 31 Jul 2023 10:28:12 GMT

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