topic Error with function IF----VERY IMPORTANT in QlikView https://community.qlik.com/t5/QlikView/Error-with-function-IF-VERY-IMPORTANT/m-p/232474#M84086 <HTML><HEAD></HEAD><BODY><P>I have an error and I don't know the solution:</P><H2>Sum(If(A='1' and B='2',C/2),(A='1' and B='3',C/4))</H2></BODY></HTML> Wed, 05 May 2010 15:40:15 GMT imoratal 2010-05-05T15:40:15Z Error with function IF----VERY IMPORTANT https://community.qlik.com/t5/QlikView/Error-with-function-IF-VERY-IMPORTANT/m-p/232474#M84086 <HTML><HEAD></HEAD><BODY><P>I have an error and I don't know the solution:</P><H2>Sum(If(A='1' and B='2',C/2),(A='1' and B='3',C/4))</H2></BODY></HTML> Wed, 05 May 2010 15:40:15 GMT https://community.qlik.com/t5/QlikView/Error-with-function-IF-VERY-IMPORTANT/m-p/232474#M84086 imoratal 2010-05-05T15:40:15Z Error with function IF----VERY IMPORTANT https://community.qlik.com/t5/QlikView/Error-with-function-IF-VERY-IMPORTANT/m-p/232475#M84087 <HTML><HEAD></HEAD><BODY><P>Your second condition needs to be a new if</P><P>Sum(if(A='1' and B='2',C/2, if (A='1' and B='3',C/4))</P></BODY></HTML> Wed, 05 May 2010 15:45:27 GMT https://community.qlik.com/t5/QlikView/Error-with-function-IF-VERY-IMPORTANT/m-p/232475#M84087 2010-05-05T15:45:27Z Error with function IF----VERY IMPORTANT https://community.qlik.com/t5/QlikView/Error-with-function-IF-VERY-IMPORTANT/m-p/232476#M84088 <HTML><HEAD></HEAD><BODY><P>I have the error again. My function is:</P><P></P><P></P><P></P><P></P><BR /><BR /> <H2 style="font-weight: bold"></H2><P style="font-weight: bold">Sum</P><P></P>(<B>If</B>(<B>ApartadoVta</B>='M2' <B>and</B> <B>Calidad</B>='2',(<B>[Cantidad Pedido]</B>*<B>CosteUnitario</B>/2), <B>If</B>(<B>ApartadoVta</B>='M2' <B>And</B> <B>Calidad</B>='3',(<B>[Cantidad Pedido]</B>*<B>CosteUnitario</B>/4 <P>))</P><BR /><BR /></BODY></HTML> Wed, 05 May 2010 15:53:42 GMT https://community.qlik.com/t5/QlikView/Error-with-function-IF-VERY-IMPORTANT/m-p/232476#M84088 imoratal 2010-05-05T15:53:42Z Error with function IF----VERY IMPORTANT https://community.qlik.com/t5/QlikView/Error-with-function-IF-VERY-IMPORTANT/m-p/232477#M84089 <HTML><HEAD></HEAD><BODY><P>Sorry is this:</P><H2>Sum(If(ApartadoVta='M2' And Calidad='2',[Cantidad Pedido]*CosteUnitario,0), If(ApartadoVta='M2' And Calidad='3',[Cantidad Pedido]*CosteUnitario,0))</H2></BODY></HTML> Wed, 05 May 2010 15:59:07 GMT https://community.qlik.com/t5/QlikView/Error-with-function-IF-VERY-IMPORTANT/m-p/232477#M84089 imoratal 2010-05-05T15:59:07Z Error with function IF----VERY IMPORTANT https://community.qlik.com/t5/QlikView/Error-with-function-IF-VERY-IMPORTANT/m-p/232478#M84090 <HTML><HEAD></HEAD><BODY><P>missing closing bracket, use <B>code</B> and <B>/code</B> enclosed in square brackets [] to make formulas easier to read.</P></BODY></HTML> Wed, 05 May 2010 16:02:29 GMT https://community.qlik.com/t5/QlikView/Error-with-function-IF-VERY-IMPORTANT/m-p/232478#M84090 2010-05-05T16:02:29Z Error with function IF----VERY IMPORTANT https://community.qlik.com/t5/QlikView/Error-with-function-IF-VERY-IMPORTANT/m-p/232479#M84091 <HTML><HEAD></HEAD><BODY><P>Sorry, it not the final closing bracket but you need to remove the closing bracket on the first line</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;"><BR />if ( &lt;condition&gt;, &lt;true&gt;, &lt;false&gt;)<BR />&lt;false&gt; can again be a full if, if( &lt;condition&gt;,&lt;true&gt;, if (&lt;condition&gt;,&lt;true&gt;,&lt;false&gt;))<BR /></PRE></BLOCKQUOTE><BR /><BR /> <P>Usually when you get a null value (standard display is "-") from formulas it is a broken syntax.</P></BODY></HTML> Wed, 05 May 2010 16:07:13 GMT https://community.qlik.com/t5/QlikView/Error-with-function-IF-VERY-IMPORTANT/m-p/232479#M84091 2010-05-05T16:07:13Z Re. :Re: Error with function IF----VERY IMPORTANT https://community.qlik.com/t5/QlikView/Error-with-function-IF-VERY-IMPORTANT/m-p/232480#M84092 <HTML><HEAD></HEAD><BODY><P>Why have you created a second post ?</P><P>You have the same answers here :</P><P><A class="ForumNameRead">Utilizar función IF DUDA</A></P></BODY></HTML> Wed, 05 May 2010 16:08:21 GMT https://community.qlik.com/t5/QlikView/Error-with-function-IF-VERY-IMPORTANT/m-p/232480#M84092 martin59 2010-05-05T16:08:21Z Re. :Re: Error with function IF----VERY IMPORTANT https://community.qlik.com/t5/QlikView/Error-with-function-IF-VERY-IMPORTANT/m-p/232481#M84093 <HTML><HEAD></HEAD><BODY><P>Sorry Martin, I had not answers but the solution are the brackets. Thanks you</P></BODY></HTML> Wed, 05 May 2010 16:13:44 GMT https://community.qlik.com/t5/QlikView/Error-with-function-IF-VERY-IMPORTANT/m-p/232481#M84093 imoratal 2010-05-05T16:13:44Z