variable in reload

Thu, 28 Nov 2013 12:32:55 GMT

Hi All,

I am trying to load a file from website and trying to automate it. I am getting a date variable in the specified format and using it as string in the load script. How to use a variable created in the module in reload script. Trigger part is all completed and stored the variable fdc in specific format (as in the comment in code below) and tested it using msgbox in the module.

Below is the reload script

rem let fdc='2013-11-14';
let fdd ='[http://www.xe.com/currencytables/?from=USD&date=$(fdc)]';

rem fdd is used in load stmt;

LOAD [Currency code ▲▼],
[Currency name ▲▼],
[Units per USD],
[USD per Unit]
FROM $(fdd)(html, codepage is 1252, embedded labels, table is @1);

The above script if I replace fdc with 2013-11-14 as in the comment stmt.

thank you in advance !

Kamal

Re: variable in reload

Wed, 04 Dec 2013 03:53:34 GMT

You can directly use the variables whci was created on the UI (Module) in the script directlt with variable name.

If you are creating two variables both on script and Module, every reload the value will be over write by the script definition.

topic Re: variable in reload in QlikView

variable in reload

Re: variable in reload