Chi2Test_chi2 - script and chart function

Chi2Test_chi2() returns the aggregated chi2-test value for one or two series of values.

If the function is used in the 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.

Note: All QlikView 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 )