topic Re: Floor Function in QlikView https://community.qlik.com/t5/QlikView/Floor-Function/m-p/1641942#M805870 <P>Thank you so much!&nbsp;</P> Fri, 01 Nov 2019 03:16:42 GMT ThienThanh 2019-11-01T03:16:42Z Floor Function https://community.qlik.com/t5/QlikView/Floor-Function/m-p/1399114#M805864 <HTML><HEAD></HEAD><BODY><P>Hi there</P><P>I'm really confused about Floor() function</P><P>why Floor(3.51,-0.5) returns 4.0 ?</P><P>why Floor(3.51,-0.9) returns 3.6 ?</P><P></P><P>how it works ,plz explain in calculation detail&nbsp; , thx</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Floor-Function/m-p/1399114#M805864 woshua5550 2020-11-25T16:16:04Z Re: Floor Function https://community.qlik.com/t5/QlikView/Floor-Function/m-p/1399115#M805865 <HTML><HEAD></HEAD><BODY><P>Please check this</P><P></P><P><A href="https://community.qlikview.com/thread/79632" title="https://community.qlikview.com/thread/79632">Doubts in understanding the ceil and floor func... | Qlik Community</A></P><P></P><P></P><P></P><P><A href="http://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/ChartFunctions/GeneralNumericFunctions/floor.htm" title="http://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/ChartFunctions/GeneralNumericFunctions/floor.htm">Floor ‒ QlikView</A></P></BODY></HTML> Thu, 02 Nov 2017 09:37:00 GMT https://community.qlik.com/t5/QlikView/Floor-Function/m-p/1399115#M805865 prma7799 2017-11-02T09:37:00Z Re: Floor Function https://community.qlik.com/t5/QlikView/Floor-Function/m-p/1399116#M805866 <HTML><HEAD></HEAD><BODY><P>Hello, Dave!</P><P></P><P>Draw a little picture for you:</P><P><IMG alt="floor_ins.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/181831_floor_ins.png" style="height: auto;" /></P><P>the negative value of the base in Floor() function returns the nearest right value</P></BODY></HTML> Thu, 02 Nov 2017 10:45:20 GMT https://community.qlik.com/t5/QlikView/Floor-Function/m-p/1399116#M805866 Sergey_Shuklin 2017-11-02T10:45:20Z Re: Floor Function https://community.qlik.com/t5/QlikView/Floor-Function/m-p/1399117#M805867 <HTML><HEAD></HEAD><BODY><P>Amazing !</P><P>Can I come to this conclusion ?</P><P>Floor(a,-b) = Ceil(a,b)</P><P>Ceil(a,-b) = Floor(a,b) ?</P></BODY></HTML> Thu, 02 Nov 2017 10:58:24 GMT https://community.qlik.com/t5/QlikView/Floor-Function/m-p/1399117#M805867 woshua5550 2017-11-02T10:58:24Z Re: Floor Function https://community.qlik.com/t5/QlikView/Floor-Function/m-p/1399118#M805868 <HTML><HEAD></HEAD><BODY><P>Yes, (at least I tried different examples) and it seems to be that your conclusion is correct <span class="lia-unicode-emoji" title=":grinning_face_with_big_eyes:">😃</span></P><P>Magic of rounding =D</P></BODY></HTML> Thu, 02 Nov 2017 11:12:56 GMT https://community.qlik.com/t5/QlikView/Floor-Function/m-p/1399118#M805868 Sergey_Shuklin 2017-11-02T11:12:56Z Re: Floor Function https://community.qlik.com/t5/QlikView/Floor-Function/m-p/1399119#M805869 <HTML><HEAD></HEAD><BODY><P>Brilliant ! thanks a lot Sergey</P></BODY></HTML> Thu, 02 Nov 2017 11:32:27 GMT https://community.qlik.com/t5/QlikView/Floor-Function/m-p/1399119#M805869 woshua5550 2017-11-02T11:32:27Z Re: Floor Function https://community.qlik.com/t5/QlikView/Floor-Function/m-p/1641942#M805870 <P>Thank you so much!&nbsp;</P> Fri, 01 Nov 2019 03:16:42 GMT https://community.qlik.com/t5/QlikView/Floor-Function/m-p/1641942#M805870 ThienThanh 2019-11-01T03:16:42Z