Skip to main content Skip to complementary content

Ceil

Ceil() rounds x up to the nearest multiple of step [+ offset]. The default value of offset is 0.

Compare with the floor function, which rounds input numbers down.

Syntax:  

Ceil(x[, step[, offset]])

Return data type: integer

Examples and results:  

  • Ceil( 2.4 ): returns 3
  • Ceil( 2.6 ): returns 3
  • Ceil( 3.88 , 0.1 ): returns 3.9
  • Ceil( 3.88 , 5 ): returns 5
  • Ceil( 1.1 , 1 ): returns 2
  • Ceil( 1.1 , 1 , 0.5 ): returns 1.5
  • Ceil( 1.1 , 1 , -0.01 ): returns 1.99

Learn more

 

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