What does the Floor function do when used in Qlik Sense?

The Floor function in Qlik Sense is designed to round numbers down to the nearest whole number or specified precision. Its primary purpose is to ensure that when a value is processed, it will always result in the largest integer less than or equal to that value. For example, applying the Floor function to the number 3.7 would return 3, while applying it to -2.3 would return -3, effectively truncating any fractional part and moving towards the lower bound.

This function is particularly useful in scenarios where you want to categorize data into whole numbers, such as assigning values to bins or creating discrete groups from continuous data. By consistently rounding down, the Floor function guarantees that you are working with integers that can be reliably used for further calculations or visual representations.

While the other choices suggest different behaviors — rounding up, returning the nearest whole number, or having no effect at all — the specific use of the Floor function is accurately described by the ability to round down, making it a valuable tool in the data preparation process within Qlik Sense.