topic How to set the result of Load * statement into variable. in QlikView

How to set the result of Load * statement into variable.

Wed, 25 Nov 2020 16:16:04 GMT

Hello Guy!,

I am new to qlikview, I want to initialize the variable with the output of the Load * statement. The result of the load * statement is completely Json object. So I want to pass this variable into java script function I create. So Is there any way? Thanks.

Re: How to set the result of Load * statement into variable.

adamdavi3s — Thu, 23 Mar 2017 11:34:39 GMT

let yourvariable = peek('[',0,'Temp);

Or something along those lines

Re: How to set the result of Load * statement into variable.

aapurva09 — Fri, 24 Mar 2017 06:48:43 GMT

Hi,

Try this:

Table1:

Load *,

Field // this should have a single value

from table;

LET Variable= peek('Field',0,'Table1'); // this will store the value from column 'Field' in 'Variable'

DROP Table Table1; //optional

Re: How to set the result of Load * statement into variable.

Fri, 24 Mar 2017 08:03:40 GMT

Even I load into a Variable like this, I still cannot pass into my javascript function.

Function Cov(JsonData)

{

...

}

When I call in Script

LOAD

Cov($(Variable))<<<<< in this line it convert Variable into the Data I set (eg. Cov({"name":"A"...)). Then this line make me error.

Thanks Guys, I am finding another way...

Re: How to set the result of Load * statement into variable.

adamdavi3s — Fri, 24 Mar 2017 08:09:07 GMT

1- You've basically just copied my answer

2- you can clearly see the table and column names in the provided screenshot

Re: How to set the result of Load * statement into variable.

Fri, 24 Mar 2017 08:24:00 GMT

What I mean is, the Compiler convert my Variable into the Data I set in runtime. Then it became syntax error.

you can try in Script Editor like this,

LOAD

JavascriptFunction({"name":"A", "Value":1})

....

It will give u syntax error.

Thanks for ur reply bro.

Re: How to set the result of Load * statement into variable.

marcus_sommer — Fri, 24 Mar 2017 09:19:20 GMT

You need to load it as string so that it looked like:

LOAD

'JavascriptFunction({"name":"A", "Value":1})' as Field

...

and if you load it from a file it should go in this direction:

Load concat(@1:n, chr(10), recno()) as Field from Source (txt, no labels);

and after that you could transfer it into variable in the way Adam suggested.

- Marcus

Re: How to set the result of Load * statement into variable.

Fri, 24 Mar 2017 09:30:53 GMT

Thanks Bro, I will try it