Peek command in the script

Tue, 21 Sep 2010 23:04:51 GMT

Have input data with field name

Value

Have statement in load script as

Let vPreValue = peek('Value');

With this statement I am trying to define a new variable

vPreValue

as the value read in for the field

Value

in the previous record

After reload, when I create a new sheet object as a chart/straight table, for the straight tagble in the expression editor under variables I see a list of available variable names to use in the straight table but I don't see the new varible

vPreValue

that I thought I defined in the load script. I am new to this, so I probably don't have the correct concept or syntax here. What am I doing wrong?

Here is what I am trying to accomplish: My data consists of a field "Date" which contains dates, and a field "Value" which contains the numeric value associated with each date. I want to define a new variable "vPreValue" for each value of "Date" that contains "Value" from the previous record.

Any suggestions.

Thanks

Bill

Peek command in the script

Wed, 22 Sep 2010 00:10:36 GMT

for using peek with just one parameter, you have to usit inside a load statement

if you are going to use peek with a variable, you have to specify the source table e.g. :

Let vPreValue = peek( 'Value', 0, TableWithValues);

0 --> You have to specify the record you want, usually , using this kind of function envolve 'for' control statement .

atte

topic Peek command in the script in QlikView

Peek command in the script

Peek command in the script