Chi2Test_chi2() returns the aggregated chi2-test value for one or two series of values.
If the function is used in the data load script, the values are iterated over a number of records as defined by a group by clause.
If the function is used in a chart expression, the values are iterated over the chart dimensions.
Information noteAll Qlik Sense chi2 -test functions have the same arguments.
Syntax:
Chi2Test_chi2(col, row, actual_value[, expected_value])
Return data type: numeric
Arguments:
| Argument | Description |
|---|---|
| col, row | The specified column and row in the matrix of values being tested. |
| actual_value | The observed value of the data at the specified col and row. |
| expected_value | The expected value for the distribution at the specified col and row. |
Limitations:
Text values, NULL values and missing values in the expression value will result in the function returning NULL.
Examples:
Chi2Test_chi2( Grp, Grade, Count )
Chi2Test_chi2( Gender, Description, Observed, Expected )