topic LOOP in QlikView

LOOP

Anonymous — Wed, 08 Dec 2010 18:36:04 GMT

Hello.

I need to loop until the amount of the "Plots":

My table is like this:
Projection Term Plots
10 11/01/2011 5

Need it to break through the field "PLOTS". In this case are five parcels, then he has to break in May. Ex:

Projection Term Plots
10 11/01/2011 5
10 11/01/2011 4
10 11/01/2011 3
10 11/01/2011 2
10 11/01/2011 1

LOOP

Anonymous — Thu, 09 Dec 2010 12:22:16 GMT

HELP...

LOOP

tresB — Thu, 09 Dec 2010 12:31:47 GMT

Hi Washington,

Could you please explain your query in another descriptive way ? i am not getting exactly what you want.

Regards,

tresesco

LOOP

maneshkhottcpl — Thu, 09 Dec 2010 12:32:58 GMT

Hi,

I need some sample data to resolve ur issue.

LOOP

Anonymous — Thu, 09 Dec 2010 17:08:24 GMT

My table is like this:

Term Date Plots
10 11/01/2011 5

I need to make a loop to repeat the record as the number of installments.
So will this way:

Term Date Plots
10 11/01/2011 5
10 11/01/2011 4
10 11/01/2011 3
10 11/01/2011 2
10 11/01/2011 1

Needs to be done in the script.

LOOP

Thu, 09 Dec 2010 19:03:38 GMT

Hi,

Perhaps something like peek('Plots') to get the "5". The concept might be something like...

tmp:

load * inline

[

term, date, plots

10,'11/10/2011',5

];

let x = peek('plots');

let y = peek('term');

let z = peek('date');

for i = 1 to $(x)

load * inline

[

term2,date2,plots2

$(y),$(z),$(i)

];

next i

LOOP

Oleg_Troyansky — Thu, 09 Dec 2010 20:25:30 GMT

Use LOAD with WHILE clause - something like this (I don't totally guarantee the syntax):


LOAD
 Term,
 Date,
 IterNo() as Plot_Number
resident
 <source table name>
WHILE
 IterNo() <= Plots
;

LOOP

Anonymous — Thu, 09 Dec 2010 21:06:52 GMT

Because this script just a record breaking quantities of parts?

tmp:

load

[

;

Let

for

i = 1 to $(x)

load

[

;

i * inline z = peek('DATA'); x = peek('PARCELAS'); * inline