Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I thought this should be simple but why can't it work:
Lookup('%A_MthAmt', '%A_MthKey', %A_MthID , 'tblCALC') - %ForecastAmt AS %Variance
Note: both the %ForecastAmt and the Lookup have values. This is what I get in the table view:
LookupValue %ForecastAmt Variance
2000 150 -
The variance should be 2000-150 so Variance should show 1850.
Any ideas?
Thanks.
a question:
does it work without the - %ForecastAmt part ???
try loading in the script and then use in next resident load
Thanks a million, Alessandro,
You're right!! I got the lookup parameter %A_MthKey wrong. The table view showed the "2000" value from the join and I wrongly assumed QlikView would tell me it can't find that field.