topic Re: Basic for...next loop in script, but can't make it to work in QlikView

Basic for...next loop in script, but can't make it to work

Anonymous — Wed, 02 Nov 2016 15:47:51 GMT

Hi everyone. I'm Christian, a Qlik newbie, and this is my first question

I have several days in a qvd file, have no problems to obtain maximun and minimun dates, and number of days between that dates

What I want to do is a loop that goes from 0 to that number of days. But I'm making something wrong. The loop always exits because of the 'if' condition rather than 'for' condition.

What I'm doing worng? Thanks in advance

cotas:

LOAD

min(Date(Floor(FechaAlta))) as minimo,

max(Date(Floor(FechaAlta))) as maximo,

max(Date(Floor(FechaAlta)))-min(Date(Floor(FechaAlta))) as dias

Resident carga;

LET vDiasInFile = 'dias';

LET vPasesInFile = 0;

for vI = 0 to '$(vDiasInFile)'

vPasesInFile = vPasesInFile + 1;

IF vI >= 10 then

EXIT For;

ENDIF

NEXT vI

Re: Basic for...next loop in script, but can't make it to work

sunny_talwar — Wed, 02 Nov 2016 16:28:02 GMT

Try this:

LET vDiasInFile = Peek('dias');

Re: Basic for...next loop in script, but can't make it to work

Anonymous — Wed, 02 Nov 2016 18:01:09 GMT

Tks sunny, will try and let you know!

Re: Basic for...next loop in script, but can't make it to work

Anonymous — Wed, 02 Nov 2016 18:19:22 GMT

It works. Tanks!!!