Editing Variables on the loading script

[#1]

Hello,

I was wondering if there is a way to edit the value of the variable on the loading script on qlikview.

for example,

Variable:

temp=1000

Load

     F1,

     $(temp) as F2,

    (Here i would like to do temp = temp + 3 or temp = temp+8 depending on some other fields)

     $(temp) as F3, (in here i would use the new temp value to a new field)

From

...

The thing is i would like the variable to keep his new value for every new row of the table.

Is it possible?

The problem above was to avoid explaining a more real and time consuming issue, but if i found out how to that variable value change on the loading script i would be set.

Thanks alot guys,

KR

[swuehl]

I believe you can't change the variable in the loading script (well, maybe using a Macro...).

But maybe you can do similar using Peek(), something like

Let vVar = 1000;

LOAD Field,

  if(recno()=1, $(vVar), peek(Var2)) as Var,

  if(recno()=1, Rangesum($(vVar),Field), Rangesum(peek(Var2),Field)) as Var2;

LOAD * INLINE [

Field

1

3

5

7

-1

];