topic load inside loop in QlikView

load inside loop

mohamed_ahid — Thu, 11 Sep 2014 15:46:45 GMT

i'm trying to construct this table :

[Semaine Analyse],

[Key Client] ,

Week,

[Transaction V0]

[Transaction V1]

using two load inside one loop .

Load

$(v) as [Semaine Analyse],

[Key Client] ,

week([Key Date]) as Week,

sum([Montant payé]) as [Transaction V0]

resident Transactions

where week ([Key Date])>=$(Semaine1) and week ([Key Date])<=$(Semaine2)

group by [Key Client], week([Key Date]) ;

and

Load

$(v) as [Semaine Analyse],

[Key Client] ,

week([Key Date]) as Week,

sum([Montant payé]) as [Transaction V1]

resident Transactions

where week ([Key Date])>=$(Semaine3) and week ([Key Date])<=$(Semaine4)

group by [Key Client], week([Key Date]) ;

the loop :

For v = 1 to 27

Let Semaine1 = week(Today())-($(v)*2);

let Semaine2 = week(Today())-($(v)*2)+$(v)-1;

Let Semaine1 = week(Today())-($(v)*2);

let Semaine2 = week(Today())-($(v)*2)+$(v)-1;

the place of my load

Next v

how to do that plz ?

thx

Re: load inside loop

mohamed_ahid — Mon, 15 Sep 2014 09:02:15 GMT

anyone have an idea ?

Re: load inside loop

tresB — Mon, 15 Sep 2014 09:06:32 GMT

Your construct looks good. Could you share your sample qvw? What is the exact issue you are facing?

Re: load inside loop

mohamed_ahid — Mon, 15 Sep 2014 09:12:14 GMT

thx for respondig ,

its working but i'm getting two tables .and that's what i don't want .

what y need is one table having this structure :

[Semaine Analyse],

[Key Client] ,

Week,

[Transaction V0]

[Transaction V1]

and using the two loads .

Re: load inside loop

MayilVahanan — Mon, 15 Sep 2014 09:15:49 GMT

Combine both the tables by using the key word "Concatenate".

Re: load inside loop

tresB — Mon, 15 Sep 2014 09:16:25 GMT

Use Concatenate keyword between the two tables.

Re: load inside loop

mohamed_ahid — Mon, 15 Sep 2014 09:31:03 GMT

it's giving bad results (calculation ) .The script create me 27 tables

Re: load inside loop

DavidFoster1 — Mon, 15 Sep 2014 09:31:26 GMT

Either use concatenate (which will double the number of rows) or use a left join between the tables (but this requires identical keys in the tables)

Re: load inside loop

CELAMBARASAN — Mon, 15 Sep 2014 09:39:57 GMT

May be try kind of this

TableA:

Load * Inline

[

Semaine Analyse, Key Client, Week, Transaction V0, Transaction V1

];

For v = 1 to 27

Let Semaine1 = week(Today())-($(v)*2);

let Semaine2 = week(Today())-($(v)*2)+$(v)-1;

Let Semaine1 = week(Today())-($(v)*2);

let Semaine2 = week(Today())-($(v)*2)+$(v)-1;

Concatenate(TableA)

Load

$(v) as [Semaine Analyse],

[Key Client] ,

week([Key Date]) as Week,

sum([Montant payé]) as [Transaction V0]

resident Transactions

where week ([Key Date])>=$(Semaine1) and week ([Key Date])<=$(Semaine2)

group by [Key Client], week([Key Date]) ;

Concatenate(TableA)

Load

$(v) as [Semaine Analyse],

[Key Client] ,

week([Key Date]) as Week,

sum([Montant payé]) as [Transaction V1]

resident Transactions

where week ([Key Date])>=$(Semaine3) and week ([Key Date])<=$(Semaine4)

group by [Key Client], week([Key Date]) ;

Next v

Re: load inside loop

mohamed_ahid — Mon, 15 Sep 2014 09:54:59 GMT

the solution is to begane by create an empty table .

thx all

Re: load inside loop

mohamed_ahid — Mon, 15 Sep 2014 10:07:20 GMT

do you know why i can't use the TableA within a load script using resident ?