topic Re: Error in my if statement in QlikView https://community.qlik.com/t5/QlikView/Error-in-my-if-statement/m-p/455922#M170222 <HTML><HEAD></HEAD><BODY><P>Thank you. The percentages are too big, What could be the problem</P></BODY></HTML> Mon, 29 Oct 2012 10:48:49 GMT 2012-10-29T10:48:49Z Error in my if statement https://community.qlik.com/t5/QlikView/Error-in-my-if-statement/m-p/455917#M170217 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #0000ff; font-size: 8pt;">&nbsp; </SPAN></P><P><SPAN style="color: #0000ff; font-size: 8pt;"></SPAN></P><P>sum</P><P></P><P></P><P><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">if</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Naedo</SPAN><SPAN style="font-size: 8pt;"> = 'Naedo',((</SPAN><SPAN style="color: #800000; font-size: 8pt;">Naedo_Collection</SPAN><SPAN style="font-size: 8pt;"> + </SPAN><SPAN style="color: #800000; font-size: 8pt;">Transfer</SPAN><SPAN style="font-size: 8pt;"> + </SPAN><SPAN style="color: #800000; font-size: 8pt;">Catch_all</SPAN><SPAN style="font-size: 8pt;">)*(-1) +(</SPAN><SPAN style="color: #800000; font-size: 8pt;">NaedoCollectedthisMorning</SPAN><SPAN style="font-size: 8pt;">))/(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Amount_due_actual</SPAN><SPAN style="font-size: 8pt;">),</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">null</SPAN></P><P><SPAN style="font-size: 8pt;">())) </SPAN></P></BODY></HTML> Thu, 25 Oct 2012 16:23:39 GMT https://community.qlik.com/t5/QlikView/Error-in-my-if-statement/m-p/455917#M170217 2012-10-25T16:23:39Z Re: Error in my if statement https://community.qlik.com/t5/QlikView/Error-in-my-if-statement/m-p/455918#M170218 <HTML><HEAD></HEAD><BODY><P>try replacing null() with 0</P></BODY></HTML> Thu, 25 Oct 2012 16:49:03 GMT https://community.qlik.com/t5/QlikView/Error-in-my-if-statement/m-p/455918#M170218 2012-10-25T16:49:03Z Re: Error in my if statement https://community.qlik.com/t5/QlikView/Error-in-my-if-statement/m-p/455919#M170219 <HTML><HEAD></HEAD><BODY><P>Thank you. The percentages are too big, What could be the problem</P></BODY></HTML> Mon, 29 Oct 2012 10:47:36 GMT https://community.qlik.com/t5/QlikView/Error-in-my-if-statement/m-p/455919#M170219 2012-10-29T10:47:36Z Re: Error in my if statement https://community.qlik.com/t5/QlikView/Error-in-my-if-statement/m-p/455920#M170220 <HTML><HEAD></HEAD><BODY><P>Thank you. The percentages are too big, What could be the problem</P></BODY></HTML> Mon, 29 Oct 2012 10:48:03 GMT https://community.qlik.com/t5/QlikView/Error-in-my-if-statement/m-p/455920#M170220 2012-10-29T10:48:03Z Re: Error in my if statement https://community.qlik.com/t5/QlikView/Error-in-my-if-statement/m-p/455921#M170221 <HTML><HEAD></HEAD><BODY><P>Thank you. The percentages are too big, What could be the problem</P></BODY></HTML> Mon, 29 Oct 2012 10:48:34 GMT https://community.qlik.com/t5/QlikView/Error-in-my-if-statement/m-p/455921#M170221 2012-10-29T10:48:34Z Re: Error in my if statement https://community.qlik.com/t5/QlikView/Error-in-my-if-statement/m-p/455922#M170222 <HTML><HEAD></HEAD><BODY><P>Thank you. The percentages are too big, What could be the problem</P></BODY></HTML> Mon, 29 Oct 2012 10:48:49 GMT https://community.qlik.com/t5/QlikView/Error-in-my-if-statement/m-p/455922#M170222 2012-10-29T10:48:49Z Re: Error in my if statement https://community.qlik.com/t5/QlikView/Error-in-my-if-statement/m-p/455923#M170223 <HTML><HEAD></HEAD><BODY><P>Thank you. The percentages are too big, What could be the problem</P></BODY></HTML> Mon, 29 Oct 2012 10:48:58 GMT https://community.qlik.com/t5/QlikView/Error-in-my-if-statement/m-p/455923#M170223 2012-10-29T10:48:58Z Re: Error in my if statement https://community.qlik.com/t5/QlikView/Error-in-my-if-statement/m-p/455924#M170224 <HTML><HEAD></HEAD><BODY><P>Thank you. The percentages are too big, What could be the problem</P></BODY></HTML> Mon, 29 Oct 2012 10:49:30 GMT https://community.qlik.com/t5/QlikView/Error-in-my-if-statement/m-p/455924#M170224 2012-10-29T10:49:30Z Re: Error in my if statement https://community.qlik.com/t5/QlikView/Error-in-my-if-statement/m-p/455925#M170225 <HTML><HEAD></HEAD><BODY><P>the % age values depends on ur values of the dividend &amp; divisor in the if statement?</P><P></P><P>if u cud post some sample values ?</P></BODY></HTML> Mon, 29 Oct 2012 10:49:38 GMT https://community.qlik.com/t5/QlikView/Error-in-my-if-statement/m-p/455925#M170225 2012-10-29T10:49:38Z Re: Error in my if statement https://community.qlik.com/t5/QlikView/Error-in-my-if-statement/m-p/455926#M170226 <HTML><HEAD></HEAD><BODY><P>pls delete multiple posts</P></BODY></HTML> Mon, 29 Oct 2012 10:50:06 GMT https://community.qlik.com/t5/QlikView/Error-in-my-if-statement/m-p/455926#M170226 2012-10-29T10:50:06Z Re: Error in my if statement https://community.qlik.com/t5/QlikView/Error-in-my-if-statement/m-p/455927#M170227 <HTML><HEAD></HEAD><BODY><P><IMG __jive_id="24355" class="jive-image" alt="Untitled.png" src="https://community.qlik.com/legacyfs/online/24355_Untitled.png" /></P><P>the % are incorrect</P></BODY></HTML> Mon, 29 Oct 2012 14:39:34 GMT https://community.qlik.com/t5/QlikView/Error-in-my-if-statement/m-p/455927#M170227 2012-10-29T14:39:34Z Re: Error in my if statement https://community.qlik.com/t5/QlikView/Error-in-my-if-statement/m-p/455928#M170228 <HTML><HEAD></HEAD><BODY><P>just check by manual calculation, what values u shud get then see how is it different form result in QV.</P><P>or post some figures here so the i can look into it</P></BODY></HTML> Tue, 30 Oct 2012 04:38:49 GMT https://community.qlik.com/t5/QlikView/Error-in-my-if-statement/m-p/455928#M170228 2012-10-30T04:38:49Z