Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

tgardne1
New 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?

Tags (1)
1 Solution

Accepted Solutions
cjohnson
Contributor II

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

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

1 Reply
cjohnson
Contributor II

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

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

Community Browser