Skip to main content Skip to complementary content

Chi2Test_p - chart function

Chi2Test_p() returns the aggregated chi2-test p value (significance) for one or two series of values. The test can be done either on the values in actual_value, testing for variations within the specified col and row matrix, or by comparing values in actual_value with corresponding values in expected_value, if specified.

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_p(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_p( Grp, Grade, Count )     

Chi2Test_p( Gender, Description, Observed, Expected )

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!