topic Re: Loading string value from a table to a variable in QlikView

Loading string value from a table to a variable

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi

My requirement is to load string value in a field from a table to variable.

Ex.

var:

id,name

1,aa

2,bb

3,cc

I want field value into a variable

I tried with peek function.

Let vName = peek('name',0,'var')

I didn't get any result.

Re: Loading string value from a table to a variable

trdandamudi — Tue, 03 Oct 2017 18:38:04 GMT

There is no issue with your code and I do get a value for the variable.

Re: Loading string value from a table to a variable

krishnacbe — Tue, 03 Oct 2017 18:50:57 GMT

The Script which you shared works perfectly. What is the issue you are facing?

Re: Loading string value from a table to a variable

rubenmarin — Tue, 03 Oct 2017 18:53:54 GMT

Hi Mallika...

var:

LOAD * Inline [

id,name

1,aa

2,bb

3,cc

];

Let vName = peek('name',0,'var');

Creates a variable named 'vName' with the stored value 'aa'.