For loop not working as expected

vikasshana — Tue, 14 Mar 2023 09:26:46 GMT

Hi,

I've below code in my load script.

LET vFiscalPeriodID=If(Month(now())=1,Year(Now())-1&'.012',Left(Year(Now()),4)&'.'&right(1000+Month(Now())-1,3));
//vFiscalPeriodID='2016.012'
LET vFiscalPeriodID2=Replace('$(vFiscalPeriodID)','.','');
LET vFiscalYear=left($(vFiscalPeriodID),4);
LET vExchangeRateYear=$(vFiscalYear);
LET vCurrentMonth = Month(Now())-1;
LET vNextMonth = num(Month(Now()));

For p=1 to 12;

LET vCY_loop= $(vFiscalYear)*1000+$(p);
LET vCY_loop2= left($(vCY_loop),4)&'.'&right($(vCY_loop),3);
LET vLY_loop= ($(vFiscalYear)-1)*1000+$(p);
LET vLY_loop2= left($(vLY_loop),4)&'.'&right($(vLY_loop),3);
LET vPeriod_loop = right($(vCY_loop),3);

For p1=3 to 12;

LET vCY_loops= $(vFiscalYear)*1000+$(p1);
LET vCY_loops2= left($(vCY_loops),4)&'.'&right($(vCY_loops),3);
LET vLY_loops= ($(vFiscalYear)-1)*1000+$(p1);
LET vLY_loops2= left($(vLY_loops),4)&'.'&right($(vLY_loops),3);
LET vPeriod_loops = right($(vCY_loops),3);

If $(p)<=$(vCurrentMonth) then

Test:
Load *, Current
from [..../test.xlsx] where [Fiscal Period] = [$(vCY_loop2)];

STORE Test INTO [..\..\Test_$(vPeriod_loop).QVD] (QVD);
Drop table Test;
End if;

If $(p1)>=$(vNextMonth) then

Test2:
Load *, Later
from [..../test.xlsx] where [Fiscal Period] = [$(vCY_loops2)];

STORE Test2 INTO [..\..\Test_$(vPeriod_loop).QVD] (QVD);
Drop table Test2;
End if;

next p;
next p1;

The output I'm looking for the first IF statement it has to start the loop from '1' and has to end at '2' where it creates two QVD's and the second IF statement it has to start the loop from '3' and has to end at '12' where it creates 9 QVD's. But for now for the first and second IF statements it is creating only 1 QVD and ending the loop and receiving error message.

Next p
Error:
End if
Error: The control statement is not correctly matched with its corresponding start statement

@PrashantSangle @tresB can you help me with this?

Re: For loop not working as expected

Marijn — Tue, 14 Mar 2023 10:56:28 GMT

Hi @vikasshana ,

Because the p1-loop is nested in the p-loop, I'd say that you'll have to switch "next p" and "next p1".

topic Re: For loop not working as expected in QlikView

For loop not working as expected

Re: For loop not working as expected