topic simple maths - subtracting in QlikView

simple maths - subtracting

Fri, 13 Jun 2014 08:39:17 GMT

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.

Re: simple maths - subtracting

alexandros17 — Fri, 13 Jun 2014 08:55:29 GMT

a question:

does it work without the - %ForecastAmt part ???

Re: simple maths - subtracting

sujeetsingh — Fri, 13 Jun 2014 08:59:21 GMT

try loading in the script and then use in next resident load

Re: simple maths - subtracting

Fri, 13 Jun 2014 09:06:08 GMT

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.