topic Re: DSE in FROM statement in QlikView

DSE in FROM statement

Thu, 08 May 2014 14:41:37 GMT

I have the following FROM statement in a LOAD:

http://finance.yahoo.com/q/hp?s=%5EDJI&a=04&b=6&c=2014&d=04&e=6&f=2014&g=d&z=66&y=0]

I want to use DSE to replace the variables (iow, I have a user selected number that I want to use). Such as this:

Currently c = 2014. I want c to equal: $(Begin_Year_Select). I tried simply defining it as c=$(Begin_Year_Select), but it does not recognize it. I am fairly certain the logic is right (as I have seen this before), I just think the syntax is wrong. I also tried ($(Begin_Year_Select)) but that gave me an error when I tried to reload the data.

Re: DSE in FROM statement

marcus_sommer — Fri, 09 May 2014 10:55:02 GMT

Use a textbox to build a complete path and if it worked transfer the logic to your load.

- Marcus

Re: DSE in FROM statement

MarcoWedel — Fri, 09 May 2014 12:56:11 GMT

SET vBegin_Year_Select = 2014;

LOAD *
From [http://finance.yahoo.com/q/hp?s=%5EDJI&a=04&b=6&c=$(vBegin_Year_Select)&d=04&e=6&f=2014&g=d&z=66&y=0]
(html, codepage is 1252, embedded labels, table is @7);

works for me.

But only when using squared brackets around the URL.

Maybe these are missing in your script?

Re: DSE in FROM statement

Fri, 09 May 2014 13:35:40 GMT

Marcus,

I actually got it to work. I was confused as when I enterer the DSE it did

not change colors (as it usually does) to let me know that I was entering a

DSE. However, once I entered it I got the results I expected. Thanks!

Re: DSE in FROM statement

Fri, 09 May 2014 16:45:18 GMT

I actually got it to work. Now I have other issues...a little to

convoluted for e-mail. I am just going to take break and try again in a

little while.

Re: DSE in FROM statement

MarcoWedel — Fri, 09 May 2014 17:44:33 GMT

Actually I wrote my answer alreay some hours ago, before you mentioned that you found the solution. My post was stuck in Moderation mode ...

... again ...