topic Re: Error in looping in QlikView

Error in looping

Anonymous — Wed, 20 Aug 2014 11:25:36 GMT

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 — Wed, 20 Aug 2014 11:27:40 GMT

Hi,

previous('%PAYCODE') will cause the error

Previous function cannot be used outside of the LOAD statement.

senpradip007 — Wed, 20 Aug 2014 11:30:53 GMT

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

for i=1 to $(VrowCount)

Anonymous — Wed, 20 Aug 2014 11:31:14 GMT

Are you sure?

should I replace it with peek()?

CELAMBARASAN — Wed, 20 Aug 2014 11:33:17 GMT

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 — Wed, 20 Aug 2014 11:33:52 GMT

Thanks Pradip,

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

Is $(Variablename) enough?