Skip to main content

NumAvg

Returns the numeric average of 1 to N arguments. If no numeric value is found, NULL is returned.

Information noteThe numavg function has been superseded by the RangeAvg - script and chart function function. Although numavg can be used, it is not recommended.

Syntax:  

NumAvg(expr1 [ , expr2, ... exprN ])

Examples and results:  

  • numavg( 1,2,4 ) returns 2.33333333
  • numavg( 1,'xyz' ) returns 1
  • numavg( null( ) 'abc' ) returns NULL

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