topic Introduce a field calculated with a variable into a LOAD statement in QlikView

Introduce a field calculated with a variable into a LOAD statement

datanibbler — Tue, 23 Apr 2013 14:57:21 GMT

Hi,

this seems like something pretty straightforward - but it doesn't work, so it cannot be that straightforward...

I define a variable (a numeric value) on the "Main" tab of my script. On another tab, I want to introduce into a LOAD statement (from a qvd) a new field calculated from

the sum of two fields from the table I am just loading (both of which are numeric values) multiplied with that numeric variable.

When I try that, I keep getting the script error message that a closing bracket is missing - but the bracketing is correct. I've checked it. In the error message, the variable is already neatly resolved, so that's all right.

Can anybody give me a hint here, there must be something one has to keep in mind when using variables that I missed.

Thanks a lot!

Best regards,

DataNibbler

Re: Introduce a field calculated with a variable into a LOAD statement

Tue, 23 Apr 2013 15:03:53 GMT

Show us your script - there might be something you're missing.

Re: Introduce a field calculated with a variable into a LOAD statement

datanibbler — Tue, 23 Apr 2013 15:32:27 GMT

Thanks for helping!

I post the code of my script - as much of it as is necessary for the question to become clear anyway.

Best regards,

DataNibbler

Re: Introduce a field calculated with a variable into a LOAD statement

Tue, 23 Apr 2013 15:50:04 GMT

Use this expression just remove outer brackets it should work

(ITEM_PACKTIMES.SALES_PACKTIME + ITEM_PACKTIMES.SALES_PROCTIME) * $(v_Min_Price) as Item_Price

Re: Introduce a field calculated with a variable into a LOAD statement

kuba_michalik — Tue, 23 Apr 2013 15:53:02 GMT

You have defined v_Min_Price with a decimal comma. Number literals in script (and the variable contents are being treated as a number literal after expansion) have to be written with a decimal point, I think. Commas in script are syntactic elements, so that's probably why it throws errors, finding a comma where it is not expected.

Re: Introduce a field calculated with a variable into a LOAD statement

datanibbler — Tue, 23 Apr 2013 16:03:55 GMT

Hi,

I have done both - I removed the outer brackets and I replaced the comma with a dot in the variable definition - and it works.

Thanks a lot!

This is solved - proceed to next problem 😉

Best regards,

DataNibbler