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

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

agrisyst — Thu, 12 Nov 2009 14:41:00 GMT

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.

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

Anonymous — Thu, 12 Nov 2009 15:38:15 GMT

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);

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

agrisyst — Thu, 12 Nov 2009 16:44:52 GMT

Fabulous!! It works. Many thanks.

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

Anonymous — Thu, 12 Nov 2009 16:48:49 GMT

It's a pleasure to help