topic Re: store value of load statement in variable in QlikView

store value of load statement in variable

Mon, 27 May 2013 10:19:40 GMT

hi all,

i want to store value of load statement in a variable. is it possible?

i have a excel file with values below:

item rate

coe 0.23

cog 0.50

i want to store in a variable like below:

let rate= load rate from excelfile where item='coe';

and rate variable should give value as 0.23

please advise with right steps

thanks

Re: store value of load statement in variable

kumarnatarajan — Mon, 27 May 2013 10:21:52 GMT

Hi,

use peek function

EX: let rate=peek( 'FieldName', 0, 'TableName' )

Re: store value of load statement in variable

Mon, 27 May 2013 10:24:14 GMT

let rate = peek(load rate from excelfile where item='coe');

like this

Re: store value of load statement in variable

Mon, 27 May 2013 10:25:10 GMT

Hi,

you can assign lookup function value as your variable value. Take a look into definition of lookup function in Reference Manual.

regards

Re: store value of load statement in variable

kumarnatarajan — Mon, 27 May 2013 10:27:04 GMT

Hi,

First read in peek function in help. See the below syntex.(Single quotes must)

EX: let rate=peek( 'FieldName', 0, 'TableName' )

FieldName = Finding field name

TableName= Finding table name

Re: store value of load statement in variable

Mon, 27 May 2013 10:49:34 GMT

Hi,

Please correct me .

You wanted to maintain Data in Excel and from that you need to fetch particular row with the some conidition and then you want to assign it to Varaible .

What i can suggest is that you can maitain the Variable directly in the Excel sheet .

So if you want to change value you can cahnge in the Excel itself instead of changing the value in thescript .

Regards

Yusuf

Re: store value of load statement in variable

Anonymous — Mon, 27 May 2013 10:56:13 GMT

tmpTable:

LOAD

item,

rate

FROM ...

WHERE item = 'coe'

;

LET vRate = PEEK('rate',-1,'tmpTable')

DROP TABLE tmpTable;