Skip to main content

Mod

ON THIS PAGE

Mod

Mod() is a modulo function that returns the non-negative remainder of an integer division. The first argument is the dividend, the second argument is the divisor, Both arguments must be integer values.

Syntax:  

Mod(integer_number1, integer_number2)

Return data type: integer

Limitations:  

integer_number2 must be greater than 0.

Examples and results:  

Examples Results

Mod( 7,2 )

Returns 1

Mod( 7.5,2 )

Returns NULL

Mod( 9,3 )

Returns 0

Mod( -4,3 )

Returns 2

Mod( 4,-3 )

Returns NULL

Mod( -4,-3 )

Returns NULL

See also

 

Join the Analytics Modernization Program

Modernize by leveraging your QlikView investment to begin using Qlik Sense on the Cloud.

Want to know more?
Remove banner from view