topic Automatic calculation in QlikView https://community.qlik.com/t5/QlikView/Automatic-calculation/m-p/423430#M157828 <HTML><HEAD></HEAD><BODY><P>Hey All,</P><P></P><P>I'm working on a Qlikview Document and I want to make an automatic sum, but I can't seem to figure out how to do it...</P><P></P><P>It works like this: I've got a number that consists of 2 different numbers: like 5.1 or 4.2</P><P>the second number can only be 0, 1 or 2 because everything above that would be divided by 3 and the rest would be 0, 1 or 2 again. So imagine I have:</P><P></P><P>4.2+5.1 then it have to be 10.0, but now it is 9.3</P><P></P><P>Can someone help me?</P><P></P><P>Thanks in advance</P></BODY></HTML> Fri, 03 May 2013 08:57:40 GMT 2013-05-03T08:57:40Z Automatic calculation https://community.qlik.com/t5/QlikView/Automatic-calculation/m-p/423430#M157828 <HTML><HEAD></HEAD><BODY><P>Hey All,</P><P></P><P>I'm working on a Qlikview Document and I want to make an automatic sum, but I can't seem to figure out how to do it...</P><P></P><P>It works like this: I've got a number that consists of 2 different numbers: like 5.1 or 4.2</P><P>the second number can only be 0, 1 or 2 because everything above that would be divided by 3 and the rest would be 0, 1 or 2 again. So imagine I have:</P><P></P><P>4.2+5.1 then it have to be 10.0, but now it is 9.3</P><P></P><P>Can someone help me?</P><P></P><P>Thanks in advance</P></BODY></HTML> Fri, 03 May 2013 08:57:40 GMT https://community.qlik.com/t5/QlikView/Automatic-calculation/m-p/423430#M157828 2013-05-03T08:57:40Z Re: Automatic calculation https://community.qlik.com/t5/QlikView/Automatic-calculation/m-p/423431#M157829 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>You can use Ceil()&nbsp; or Floor() functions.</P></BODY></HTML> Fri, 03 May 2013 09:41:02 GMT https://community.qlik.com/t5/QlikView/Automatic-calculation/m-p/423431#M157829 sujeetsingh 2013-05-03T09:41:02Z