topic Re: String variable in URL ? in QlikView

String variable in URL ?

christophebrault — Wed, 23 Nov 2011 11:30:14 GMT

Hi,

In my App, i want to scan a website.

I pass variables in the URL with for each instruction and for to.

I have a field with data like :'LU0123437'

I can't get this value in a variable and make it work in the URL. When I take only '0123437' it works fine but with 'LU0123437', no.

Any idea ?

sushil353 — Wed, 23 Nov 2011 12:00:54 GMT

Hi ,

field name is FIELD which contains data like LU0123437

then create a variable and apply =http://www.xyz.&getfieldselections(FIELD)&

using getfieldselection function u can get the value what ever selected and then u can call the variable

using any button, trigger or macro.

Hope it will help u

Thanks

christophebrault — Wed, 23 Nov 2011 13:52:48 GMT

That's not exactly my problem i think.

My problem is in the script

A=;

for each A in Fieldvaluelist('MyFIELD')

let vURL='www.mywebsite'&$(A)&'endoftheURL'

LOAD * FROM $(vURL)

when MyFIELD begin with letters, my variable A return '' in the URL and make an error while loading...

pho3nix90 — Mon, 13 Oct 2014 08:01:03 GMT

This is an old post, but still unanswered. So here is an answer.

The below is referring to the variable as a numerical value. Surround it by quotes.

let vURL='www.mywebsite'&$(A)&'endoftheURL'

Like this

let vURL='www.mywebsite$(A)endoftheURL'