topic Re: if(isnull) statement in App Development https://community.qlik.com/t5/App-Development/if-isnull-statement/m-p/1154426#M20809 <HTML><HEAD></HEAD><BODY><P>Thanks for the reply,</P><P></P><P>but i'm getting 'Grabage after expression: 'not'</P></BODY></HTML> Thu, 14 Jul 2016 08:08:44 GMT 2016-07-14T08:08:44Z if(isnull) statement https://community.qlik.com/t5/App-Development/if-isnull-statement/m-p/1154424#M20807 <HTML><HEAD></HEAD><BODY><P>Try to use this formula but i'm getting 'Error in Expression: If takes 2-3 parameters'</P><P></P><P>Help me with this to work properly.</P><P></P><P></P><P></P><P><STRONG>if(isnull([SHIP_DT]) = false and isnull([P_RETURN_DT])=false) then</STRONG></P><P><STRONG>(sum(([SALE_RPRICE])*([ORDER_QTY]))*(-1));</STRONG></P><P><STRONG>else if(isnull([SHIP_DT])=false and isnull([P_RETURN_DT])=true) then</STRONG></P><P><STRONG>sum(([SALE_RPRICE])*([ORDER_QTY]));</STRONG></P><P><STRONG>else</STRONG></P><P><STRONG>'0';</STRONG></P><P><STRONG>end if</STRONG></P><P></P><P></P><P></P><P>Thank you</P></BODY></HTML> Thu, 14 Jul 2016 06:15:30 GMT https://community.qlik.com/t5/App-Development/if-isnull-statement/m-p/1154424#M20807 2016-07-14T06:15:30Z Re: if(isnull) statement https://community.qlik.com/t5/App-Development/if-isnull-statement/m-p/1154425#M20808 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG>if not isnull([SHIP_DT])&nbsp; and not isnull([P_RETURN_DT]) then</STRONG></P><P><STRONG>(sum(([SALE_RPRICE])*([ORDER_QTY]))*(-1));</STRONG></P><P><STRONG>else if not isnull([SHIP_DT]) and isnull([P_RETURN_DT]) then</STRONG></P><P><STRONG>sum(([SALE_RPRICE])*([ORDER_QTY]));</STRONG></P><P><STRONG>else</STRONG></P><P><STRONG>'0';</STRONG></P><P><STRONG>end if</STRONG></P></BODY></HTML> Thu, 14 Jul 2016 07:07:05 GMT https://community.qlik.com/t5/App-Development/if-isnull-statement/m-p/1154425#M20808 sushil353 2016-07-14T07:07:05Z Re: if(isnull) statement https://community.qlik.com/t5/App-Development/if-isnull-statement/m-p/1154426#M20809 <HTML><HEAD></HEAD><BODY><P>Thanks for the reply,</P><P></P><P>but i'm getting 'Grabage after expression: 'not'</P></BODY></HTML> Thu, 14 Jul 2016 08:08:44 GMT https://community.qlik.com/t5/App-Development/if-isnull-statement/m-p/1154426#M20809 2016-07-14T08:08:44Z Re: if(isnull) statement https://community.qlik.com/t5/App-Development/if-isnull-statement/m-p/1154427#M20810 <HTML><HEAD></HEAD><BODY><P>How about this?</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">If(Len(Trim([SHIP_DT])) &gt; 0 and Len(Trim([P_RETURN_DT])) &gt; 0, </STRONG><STRONG style="font-family: inherit; line-height: 1.5em; font-style: inherit;">Sum(([SALE_RPRICE])*([ORDER_QTY])) * (-1),</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">If(Len(Trim([SHIP_DT])) &gt; 0 and Len(Trim([P_RETURN_DT])) = 0, S</STRONG><STRONG style="font-style: inherit; font-family: inherit;">um(([SALE_RPRICE])*([ORDER_QTY])), 0))</STRONG></P></BODY></HTML> Thu, 14 Jul 2016 11:09:27 GMT https://community.qlik.com/t5/App-Development/if-isnull-statement/m-p/1154427#M20810 sunny_talwar 2016-07-14T11:09:27Z