topic Re: Problem with using a variable in the script in QlikView

Problem with using a variable in the script

thanhphongle — Fri, 22 Sep 2017 08:17:25 GMT

Hello Community,

I have a problem with using a variable in a script.

See here:

Data:

LOAD *,

((Year(contract_end_date_cur)-year($(v_target_date)))*12+month(contract_end_date_cur)-month($(v_target_date))) as contract_term_remain;

Directory;

LOAD main_unique_id,

customer,

asset_model,

contract_start_date,

contract_end_date_cur

FROM

lease.one_import.xlsx

(ooxml, embedded labels, table is main);

let v_target_date = today();

QV returns me this error:

Error in expression:

')' expected

Data:

LOAD *,

((Year(contract_end_date_cur)-year(21.09.2017))*12+month(contract_end_date_cur)-month(21.09.2017)) as contract_term_remain;

I checked my expression. There's definetely not a ) missing.

Hope anyone can help me out here.

Re: Problem with using a variable in the script

prieper — Fri, 22 Sep 2017 09:12:22 GMT

Looks fine for me as well ....

does the script continue, i.e. why is there a ";" at the end of the statement?

Else would suggest to rewrite the expression (sometimes there might still be a bracket at the very right of the text),

or go through step-by-step.

Re: Problem with using a variable in the script

marcus_sommer — Fri, 22 Sep 2017 10:38:12 GMT

I could imagine that the format of the variable is causing the error. Therefore either change the content of your variable to num(today()) or maybe floor(today()) or change the call of the variable to '$(v_target_date)'.

- Marcus

Re: Problem with using a variable in the script

thanhphongle — Fri, 22 Sep 2017 10:42:16 GMT

"does the script continue, i.e. why is there a ";" at the end of the statement?"

No, the script just ends there.

I tried to rewrite the expression several times, but the brackets are fine.

Re: Problem with using a variable in the script

thanhphongle — Fri, 22 Sep 2017 10:53:31 GMT

Thank you very much, it finally works !!

Your solutions

floor(today()) works,

'$(v_target_date)' works,

num(today()) does not work

THX!!