topic Re: Next inside and If Then in QlikView

Next inside and If Then

debutler — Mon, 13 Oct 2014 23:34:55 GMT

I need to cycle through a bunch of files being generated by another program.

If the file is empty I need to skip to the next file.

I am getting a script error on the next inside of the if statement.

Any ideas. If you comment out the if statement this works. If you remove the next and add other logic this works.

for Each v_file in a.qvd, b.qvd, c.qvd

Let vQVDExists = if(FileSize(v_file) > 0, -1, 0);

IF $(vQVDExists)=0 THEN
next
END IF;

// Do load of file here

next

Re: Next inside and If Then

anbu1984 — Tue, 14 Oct 2014 01:14:26 GMT

for Each v_file in a.qvd, b.qvd, c.qvd

Let vQVDExists = if(FileSize(v_file) > 0, -1, 0);

IF $(vQVDExists)<>0 THEN

// Do load of file here

END IF;

next

Re: Next inside and If Then

jagan — Tue, 14 Oct 2014 02:06:15 GMT

Hi,

Try like this

for Each v_file in a.qvd, b.qvd, c.qvd

IF FileSize($(v_file)) = 0 THEN

LOAD

FROM v_file;

END IF;

next

Re: Next inside and If Then

Peter_Cammaert — Tue, 14 Oct 2014 08:19:03 GMT

Or if you do not want to read the data from empty files:

FOR Each v_file IN a.qvd, b.qvd, c.qvd

IF FileSize($(v_file)) > 0 THEN

LOAD

FROM v_file;

END IF;

NEXT

Re: Next inside and If Then

debutler — Tue, 14 Oct 2014 17:22:03 GMT

Reversing the logic so I do not need the NEXT inside the if will work for this problem.

However it still doesn't explain why you can not use NEXT inside an IF statement.

I am curious to know if NEXT is not allowed or do I have some semantic issue I am missing to make that work.

Thanks for all the helpful responses.

Re: Next inside and If Then

anbu1984 — Wed, 15 Oct 2014 01:11:54 GMT

Next clause comes with For each control statement. You cannot use Next alone to skip the loop.

Re: Next inside and If Then

Peter_Cammaert — Thu, 16 Oct 2014 08:12:15 GMT

Indeed.

NEXT is the FOR loop terminator and signals the semantic end of the FOR loop.

Exiting the FOR loop can be accomplished by specifying EXIT FOR; somewhere in the body of the FOR loop.

However, in VBScript there is no statement that prematurely skips the FOR body code in order to continue with the next iteration, as CONTINUE FOR does in Visual Basic.

It's all to be done using IF THEN ELSE logic...