Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2011-05-24 08:56 PM

If statement in load pulling from different table

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.

if(Ship_Date__c <>''  and Booked_on_AS400__c  <>'' and Rev_Rec__c > Today(),ProductsOTR_Price,0) as RecognizedRevenue,

Is there a way to have this statement load from different tables.

Thanx

2,663 Views
0 Likes
0 Replies