topic If statement in load pulling from different table in QlikView https://community.qlik.com/t5/QlikView/If-statement-in-load-pulling-from-different-table/m-p/324807#M119653 <HTML><HEAD></HEAD><BODY><P>I have an if expression that I am using in the load script. My conditions are all from the same table but the sum field is from a different table.</P><P>if(Ship_Date__c &lt;&gt;''&nbsp; and Booked_on_AS400__c&nbsp; &lt;&gt;'' and Rev_Rec__c &gt; Today(),ProductsOTR_Price,0) as RecognizedRevenue,</P><P></P><P>Is there a way to have this statement load from different tables.</P><P></P><P>Thanx</P></BODY></HTML> Wed, 25 May 2011 00:56:29 GMT 2011-05-25T00:56:29Z If statement in load pulling from different table https://community.qlik.com/t5/QlikView/If-statement-in-load-pulling-from-different-table/m-p/324807#M119653 <HTML><HEAD></HEAD><BODY><P>I have an if expression that I am using in the load script. My conditions are all from the same table but the sum field is from a different table.</P><P>if(Ship_Date__c &lt;&gt;''&nbsp; and Booked_on_AS400__c&nbsp; &lt;&gt;'' and Rev_Rec__c &gt; Today(),ProductsOTR_Price,0) as RecognizedRevenue,</P><P></P><P>Is there a way to have this statement load from different tables.</P><P></P><P>Thanx</P></BODY></HTML> Wed, 25 May 2011 00:56:29 GMT https://community.qlik.com/t5/QlikView/If-statement-in-load-pulling-from-different-table/m-p/324807#M119653 2011-05-25T00:56:29Z