6 Replies Latest reply: Jun 27, 2013 4:10 AM by Satti Aluri RSS

    Doubts in understanding the ceil and floor functions

      Hi to all,

      From qlikview help i knew how the ceil and floor functions works,but still i have some doubts in these two functions.

       

      Ex1.ceil( 1.1 , 1 , 0.5 ) returns 1.5

      ex2.Ceil(2.6, 0.25) returns 2.75

       

      internally how ceil() works in above 2 examples

       

      ex1.floor( 3.88 , 5 ) returns 0
      ex2.floor( 1.1 , 1 , 0.5 ) returns 0.5
      ex3.Floor(2.6, 0.25) returns 2.5

      Internally how floor() works in above 3 examples.

       

      Prior to this posting i had searched in the google,qlikview reference manual and in the book qlikview 11 for developers.But i didn't get any thing.

      Can any one please helpme in the layman language as early as possible.

      Thanks in advance.