T_SQL PERCENTILE_DISC function in Qlikview

felix18807 — Sat, 16 Nov 2024 19:43:43 GMT

https://docs.microsoft.com/en-us/sql/t-sql/functions/percentile-disc-transact-sql?view=sql-server-ver15

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.

Re: T_SQL PERCENTILE_DISC function in Qlikview

Brett_Bleess — Tue, 12 Nov 2019 19:07:36 GMT

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

topic T_SQL PERCENTILE_DISC function in Qlikview in QlikView

T_SQL PERCENTILE_DISC function in Qlikview

Re: T_SQL PERCENTILE_DISC function in Qlikview