Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
!Please take a look at the Fractile function as described in the following:
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.
!Please take a look at the Fractile function as described in the following:
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.