Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Computes a specific percentile for sorted values in an entire rowset or within a rowset's distinct partitions in SQL Server. For a given percentile value P, PERCENTILE_DISC sorts the expression values in the ORDER BY clause. It then returns the value with the smallest CUME_DIST value given (with respect to the same sort specification) that is greater than or equal to P. For example, PERCENTILE_DISC (0.5) will compute the 50th percentile (that is, the median) of an expression. PERCENTILE_DISC calculates the percentile based on a discrete distribution of the column values. The result is equal to a specific column value.
Is it possible to replicate this in QV script? Fractile is different.
Only thing I have is the following Design Blog post that may be along the right line:
https://community.qlik.com/t5/Qlik-Design-Blog/Recipe-for-a-Pareto-Analysis/ba-p/1468497
There are a couple of other links at the bottom of the post, just FYI, so be sure to check those too, hopefully this helps get you on the right track. If you want to search around further, here is the base URL of the Design Blog area:
https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog
Regards,
Brett