topic Error: ')' expected in QlikView

Error: ')' expected

Linh_Nguyen — Sat, 16 Nov 2024 00:15:51 GMT

I have a script that has been running fine for years. today it failed several times and this is the part where there was an error. The script looks good to me but the variables disappeared in the error message and it says I need a ')'. Could anyone show me what is wrong here?

I have checked these variables (vlocalExchangeRateEUR..) and they all return correct values.

Script:

LOAD
PrimaryKey,
If((Org='1000' or Org='1600' or Org='1500') and CurrencyIsoCode='USD', Cost,
If((Org='1000' or Org='1600' or Org='1500') and CurrencyIsoCode='EUR',Cost/$(vLocalExchangeRateEUR),
If((Org='3000') and CurrencyIsoCode='CNY',Cost/$(vLocalExchangeRateCNY),
If((Org='3300') and CurrencyIsoCode='JPY',Cost/$(vLocalExchangeRateJPY)

)))) as CostLC
Resident Quote;

Error message:

Error in expression:
')' expected
Left Join(Quote)
LOAD
PrimaryKey,
If((Org='1000' or Org='1600' or Org='1500') and CurrencyIsoCode='USD', Cost,
If((Org='1000' or Org='1600' or Org='1500') and CurrencyIsoCode='EUR',Cost/,
If((Org='3000') and CurrencyIsoCode='CNY',Cost/,
If((Org='3300') and CurrencyIsoCode='JPY',Cost/

)))) as CostLC
Resident Quote

Re: Error: ')' expected

dplr-rn — Fri, 24 Jul 2020 16:08:37 GMT

the variables looks to be empty vLocalExchangeRateCNY , vLocalExchangeRateEUR

its likely because of that.

beause script is looking for column Cost/

Re: Error: ')' expected

rubenmarin — Sat, 25 Jul 2020 09:04:11 GMT

Hi, as @dplr-rn says and you probably guess the error is in those variables, how have you checked that the variables has any values at that point in script?

You can use 'exit script;' to stop the script at any point and check the loaded values for the variables, and also you can use the 'trace' sentence.

Also note that in script a point is used as decimal separator, maybe your expression to calculate rates are returning comma as decimal separator and causing the rates to go null() at some point before that script.