Skip to main content Skip to complementary content

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.

Information noteAll QlikView chi2 -test functions have the same arguments.

Syntax:  

Chi2Test_chi2(col, row, actual_value[, expected_value])

Return data type: numeric

Arguments:  

  • 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 )  

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!

Join the Analytics Modernization Program

Remove banner from view

Modernize without compromising your valuable QlikView apps with the Analytics Modernization Program. Click here for more information or reach out: ampquestions@qlik.com