Statistical distribution functions return the probabilities of occurrence of different possible outcomes for a given input variable. You can use these functions to calculate the potential values of your data points.
The three groups of statistical distribution functions described below are all implemented in Qlik Sense using the Cephes function library. For references and details on algorithms used, accuracy, and so on, see: Cephes library.
The Cephes function library is used by permission.
The probability functions calculate the probability at the point in the distribution given by the supplied value.
The Frequency functions are used for discrete distributions.
The Density functions are used for continuous functions.
The Dist functions calculate the accumulated probability of the distribution at the point in the distribution given by the supplied value.
The Inv functions calculate the inverse value, given the accumulated probability of the distribution.
All functions can be used in both the data load script and in chart expressions.
Use the drop-down on each function to see a brief description and the syntax of each function. Click the function name in the syntax description for further details.
BetaDensity() returns the probability of the Beta distribution.
NormDist() returns the cumulative normal
distribution for the specified mean and standard deviation. If mean = 0
and standard_dev = 1, the function returns the standard normal distribution.
TDensity() returns the value for the student's t density function where a numeric value is a calculated value of t for which the probability is to be computed.
TDist() returns the probability for the
student's t distribution where a numeric value is a calculated value of t for which the probability is to be computed.
The load script is a sequence of statements that defines what data to load and how to link the different loaded tables. It can be generated with the Data manager, or with the Data load editor, where it also can be viewed and edited.
