Error in looping

[Anonymous]

Hi,

Can anybody help me to understand the error in following looping part:

let Vrowcount=NoOfRows('Temp');

for i=1 to $(VrowCount)

let VAccuCL=if(%PAYCODE <> previous('%PAYCODE'), Accu_CL, peek('ClosingBalance',$(i),'Temp'));

let VCLAccrued=FieldValue('CLA',$(i));

let VCLclosingbalance=rangesum(if(%PAYCODE <>previous(%PAYCODE),Accu_CL,peek('ClosingBalance',$(i),'Temp')),-$(VCLAccrued));

next;

Please suggest.

[CELAMBARASAN]

Hi,

previous('%PAYCODE') will cause the error

Previous function cannot be used outside of the LOAD statement.

[senpradip007]

Look into the variable name you are using QlikView Script is case sensitive.

for i=1 to $(VrowCount)

[Anonymous]

Are you sure?

should I replace it with peek()?

[CELAMBARASAN]

Yeah and also you cannot use %PAYCODE field as it is, outside the load script.

Can you tell what you are trying to do

[Anonymous]

Thanks Pradip,

Could you help me how I can use these variable at front end?

Is $(Variablename)  enough?