Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
tgardne1
Contributor II
Contributor II

Can I use Percentile in place of using the AVG function?

I have set my dashboard to calculate avg of items under a set amount.  The customer decided they want the 90th percentile, is there a way to use a percentile function to replace the AVG function?

1 Solution

Accepted Solutions
cjohnson
Partner - Creator II
Partner - Creator II

!Please take a look at the Fractile function as described in the following:

percentile calculation

To compute percentiles in QlikView, use the fractile() function. Fractile(Score,0.50) is the same as median(Score). Fractile(Score,0.90) is the 90th percentile.

View solution in original post

1 Reply
cjohnson
Partner - Creator II
Partner - Creator II

!Please take a look at the Fractile function as described in the following:

percentile calculation

To compute percentiles in QlikView, use the fractile() function. Fractile(Score,0.50) is the same as median(Score). Fractile(Score,0.90) is the 90th percentile.