
Contributor III
2023-07-29
06:04 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Calculation for percentile of a value
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?
2 Replies

Specialist
2023-07-31
03:47 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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)))
1,009 Views

Contributor III
2023-07-31
06:28 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
995 Views
