Make part of 'FROM' statement variable when loading from the Internet

[agrisyst]

Hello,

I am wondering whether it is possible to make the dates variable when loading dat from the Internet in a FROM statement which looks like this....

FROM

[https://www.xxxx.xx/scripts/syssys.exe?S_S_SSSSSSS_SS&01.11.2009&15.11.2009&&&&&&&&&]

(

html, codepage is 1252, embedded labels, table is @3)

I can change the data in the script but is there a way to do this automatically or to do this from the document setting a variable? It would be a great help if somebody has some ideas.... I am an intermediate user of Qlikview.

[Anonymous · Accepted solution]

Hi,

You will need 3 variables: two for date period and one for From statement

Variables:

• FromDate
• ToDate
• FromString

Code will look like...

LET FromString = '[https://www.xxxx.xx/scripts/syssys.exe?S_S_SSSSSSS_SS&' & '$(FromDate)' & '&' & '$(ToDate)' & '&&&&&&&&&]';

Load *
FROM $(FromString) (html, codepage is 1252, embedded labels, table is @3);

[agrisyst]

Fabulous!! It works. Many thanks.

[Anonymous]

It's a pleasure to help