topic Re: how to optimized code with functions in QlikView https://community.qlik.com/t5/QlikView/how-to-optimized-code-with-functions/m-p/445441#M1154084 <HTML><HEAD></HEAD><BODY><P>try: floor(column(1)/20)</P></BODY></HTML> Fri, 15 Mar 2013 11:42:42 GMT Gysbert_Wassenaar 2013-03-15T11:42:42Z how to optimized code with functions https://community.qlik.com/t5/QlikView/how-to-optimized-code-with-functions/m-p/445440#M1154083 <HTML><HEAD></HEAD><BODY><P>if(column(1)&gt;=20 and column(1)&lt;=39,1,</P><P>if(column(1)&gt;=40 and column(1)&lt;=59,2,</P><P>if(column(1)&gt;=60 and column(1)&lt;=79,3,</P><P>if(column(1)&gt;=80 and column(1)&lt;=99,4,</P><P>if(column(1)&gt;=100 and column(1)&lt;=119,5,</P><P>if(column(1)&gt;=120 and column(1)&lt;=139,6,</P><P>if(column(1)&gt;=140 and column(1)&lt;=159,7)))))))</P></BODY></HTML> Fri, 15 Mar 2013 11:38:34 GMT https://community.qlik.com/t5/QlikView/how-to-optimized-code-with-functions/m-p/445440#M1154083 2013-03-15T11:38:34Z Re: how to optimized code with functions https://community.qlik.com/t5/QlikView/how-to-optimized-code-with-functions/m-p/445441#M1154084 <HTML><HEAD></HEAD><BODY><P>try: floor(column(1)/20)</P></BODY></HTML> Fri, 15 Mar 2013 11:42:42 GMT https://community.qlik.com/t5/QlikView/how-to-optimized-code-with-functions/m-p/445441#M1154084 Gysbert_Wassenaar 2013-03-15T11:42:42Z