topic Re: Ceil in QlikView https://community.qlik.com/t5/QlikView/Ceil/m-p/46009#M7677 <HTML><HEAD></HEAD><BODY><P>One work around would be to do this</P><P></P><P><STRONG style="text-decoration: line-through;">=Ceil(Round(1092/364, 0.1))</STRONG></P><P>=Ceil(Round(1092/364, 0.00000000001))</P></BODY></HTML> Fri, 02 Feb 2018 18:13:26 GMT sunny_talwar 2018-02-02T18:13:26Z Ceil https://community.qlik.com/t5/QlikView/Ceil/m-p/46006#M7674 <HTML><HEAD></HEAD><BODY><P>Hello</P><P></P><P>Does anyone knows, why the result of Ceil(1092/364) is 4 ??? It should be 3 <IMG src="https://community.qlik.com/legacyfs/online/emoticons/confused.png" /> Or am I wrong?</P></BODY></HTML> Fri, 02 Feb 2018 17:43:45 GMT https://community.qlik.com/t5/QlikView/Ceil/m-p/46006#M7674 coxanagi 2018-02-02T17:43:45Z Re: Ceil https://community.qlik.com/t5/QlikView/Ceil/m-p/46007#M7675 <HTML><HEAD></HEAD><BODY><P>Seems like rounding error problem</P><P><A href="https://community.qlik.com/qlik-blogpost/3471">Rounding Errors</A></P></BODY></HTML> Fri, 02 Feb 2018 17:47:53 GMT https://community.qlik.com/t5/QlikView/Ceil/m-p/46007#M7675 sunny_talwar 2018-02-02T17:47:53Z Re: Ceil https://community.qlik.com/t5/QlikView/Ceil/m-p/46008#M7676 <HTML><HEAD></HEAD><BODY><P><STRONG>Ceil</STRONG> will round the value when it exceeds (means 3.0003 should result to 4)</P><P>If you want 3 as a result you can go with <STRONG>floor</STRONG>(as it takes integer part)</P><P>else you can go with <STRONG>round</STRONG> based on requirement.</P></BODY></HTML> Fri, 02 Feb 2018 18:01:45 GMT https://community.qlik.com/t5/QlikView/Ceil/m-p/46008#M7676 surendraj 2018-02-02T18:01:45Z Re: Ceil https://community.qlik.com/t5/QlikView/Ceil/m-p/46009#M7677 <HTML><HEAD></HEAD><BODY><P>One work around would be to do this</P><P></P><P><STRONG style="text-decoration: line-through;">=Ceil(Round(1092/364, 0.1))</STRONG></P><P>=Ceil(Round(1092/364, 0.00000000001))</P></BODY></HTML> Fri, 02 Feb 2018 18:13:26 GMT https://community.qlik.com/t5/QlikView/Ceil/m-p/46009#M7677 sunny_talwar 2018-02-02T18:13:26Z