topic Re: how to express Roundup function in QlikView https://community.qlik.com/t5/QlikView/how-to-express-Roundup-function/m-p/432785#M699324 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>This should do it:</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LEFT(period, 4) &amp; "Q" &amp; CEIL(RIGHT(period, 2) / 3, 0)</P><P></P><P>Regards</P><P>Jonathan</P></BODY></HTML> Thu, 13 Dec 2012 06:17:56 GMT jonathandienst 2012-12-13T06:17:56Z how to express Roundup function https://community.qlik.com/t5/QlikView/how-to-express-Roundup-function/m-p/432784#M699323 <HTML><HEAD></HEAD><BODY><P>in excel when period = 201102， </P><P>Quarter(2011Q1)= LEFT(period,4)&amp;"Q"&amp;ROUNDUP(RIGHT(period,2)/3,0)</P><P>But Roundup function is not valid in Qlikview</P><P>so how can I change 201102 into 2011Q1 with Qlikview language?</P></BODY></HTML> Thu, 13 Dec 2012 06:11:10 GMT https://community.qlik.com/t5/QlikView/how-to-express-Roundup-function/m-p/432784#M699323 2012-12-13T06:11:10Z Re: how to express Roundup function https://community.qlik.com/t5/QlikView/how-to-express-Roundup-function/m-p/432785#M699324 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>This should do it:</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LEFT(period, 4) &amp; "Q" &amp; CEIL(RIGHT(period, 2) / 3, 0)</P><P></P><P>Regards</P><P>Jonathan</P></BODY></HTML> Thu, 13 Dec 2012 06:17:56 GMT https://community.qlik.com/t5/QlikView/how-to-express-Roundup-function/m-p/432785#M699324 jonathandienst 2012-12-13T06:17:56Z