Skip to main content

The Qlik February 2020 release has been delayed by a couple of weeks due to a security vulnerability that recently surfaced with Node.js, which is impacting a large portion of the software industry. The release is expected to be delivered before the end of the month, with a target date of February 25th, as Qlik is actively running tests to ensure that the February GA release is stable and not affected by this security malware.
To read more about this vulnerability: https://nodejs.org/en/blog/vulnerability/february-2020-security-releases/

QlikWorld 2020 Global Conference. Keynote speaker Malcolm Gladwell. Register now and save

Floor - script and chart function

Floor() rounds down a number to the nearest multiple of the step shifted by the offset number.

Compare with the ceil function, which rounds input numbers up.

Syntax:

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

Return data type: numeric

Arguments:

Argument	Description
x	Input number.
step	Interval increment. The default value is 1.
offset	Defines the base of the step interval. The default value is 0.

Examples and results:

Examples	Results
Floor(2.4)	Returns 2 In this example, the size of the step is 1 and the base of the step interval is 0. The intervals are ...0 <= x <1, 1 <= x < 2, 2<= x <3, 3<= x <4....
Floor(4.2)	Returns 4
Floor(3.88 ,0.1)	Returns 3.8 In this example, the size of the interval is 0.1 and the base of the interval is 0. The intervals are ... 3.7 <= x < 3.8, 3.8 <= x < 3.9, 3.9 <= x < 4.0...
Floor(3.88 ,5)	Returns 0
Floor(1.1 ,1)	Returns 1
Floor(1.1 ,1,0.5)	Returns 0.5 In this example, the size of the step is 1 and the offset is 0.5. It means that the base of the step interval is 0.5 and not 0. The intervals are ...0.5 <= x <1.5, 1.5 <= x < 2.5, 2.5<= x <3.5,...

See also: