Ga naar hoofdinhoud

Round function

Videominiatuur
Learn how the ROUND function works in Qlik Sense, including syntax, practical examples, and tips for rounding numbers in dashboards and reports. This video covers rounding to the nearest integer, using step values, applying offsets, and rounding decimals—helping you format numbers precisely for charts, KPIs, and tables. 🟢 00:00 Introduction – Overview of the round function 📐 00:07 Function purpose – formatting numbers and precision 🔢 00:25 How rounding works – nearest multiples 📝 00:42 Syntax breakdown: X, Step, Offset 🔄 00:57 Default rounding to nearest integer 📊 01:03 Example: rounding sales amount ➕ 01:24 Using step values 🔢 01:38 Example: step 4 and step 6 🔙 01:50 Returning to table for step rounding 📈 02:03 Rounding examples in table rows 🔢 02:19 Rounding with decimal precision ⚖️ 02:40 Using offset to shift rounding intervals 🧮 03:08 Applying offset rounding to data ✅ 03:29 Conclusion