Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
You will need 3 variables: two for date period and one for From statement
Variables:
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);
Hi,
You will need 3 variables: two for date period and one for From statement
Variables:
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);
Fabulous!! It works. Many thanks.
It's a pleasure to help