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

[tgardne1]

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?

[cjohnson · Accepted solution]

!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.