Skip to main content Skip to complementary content

ZTest_z - script and chart function

ZTest_z() returns the aggregated z value for a 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.

Syntax:  

ZTest_z(value[, sigma])

Return data type: numeric

Arguments:  

  • value: The sample values to be evaluated. A population mean of 0 is assumed. If you want the test to be performed around another mean, subtract that mean from the sample values.
  • sigma: If known, the standard deviation can be stated in sigma. If sigma is omitted the actual sample standard deviation will be used.

Limitations:  

Text values, NULL values and missing values in the expression value will result in the function returning NULL.

Example:  

ZTest_z( Value-TestValue )

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