Loop in QlikView SCript will not work

Fri, 30 Jan 2015 09:31:54 GMT

I Try to make a Loop in my QlikView Script but it will not work.

Can someone tell my what i do wrong.

UITVOERDERS:

LOAD

SUBFIELD(REPLACE(Subfield(item_lijst,';',1), ',', ';'), ';',1) AS Uitvoerder,

SUBFIELD(REPLACE(item_code_lijst, ',', ';'), ';',1) AS Uitvoerder_Code

;

SQL SELECT *

FROM mtc_rubriek

WHERE rubcode = 'PROJ_006';

UITVOERDERS:

LOAD

SUBFIELD(REPLACE(Subfield(item_lijst,';',1), ',', ';'), ';',2) AS Uitvoerder,

SUBFIELD(REPLACE(item_code_lijst, ',', ';'), ';',2) AS Uitvoerder_Code

;

SQL SELECT *

FROM mtc_rubriek

WHERE rubcode = 'PROJ_006';

UITVOERDERS:

LOAD

SUBFIELD(REPLACE(Subfield(item_lijst,';',1), ',', ';'), ';',3) AS Uitvoerder,

SUBFIELD(REPLACE(item_code_lijst, ',', ';'), ';',3) AS Uitvoerder_Code

;

SQL SELECT *

FROM mtc_rubriek

WHERE rubcode = 'PROJ_006';

This is the script total write down but than 10 times.

I Want to make a loop of it.

UITVOERDERSAANTAL:

LOAD

COUNT(DISTINCT(UitvoerderAantal)) AS MAXUITVOERDERS;

LOAD

SUBFIELD(REPLACE(Subfield(item_lijst,';',1), ',', ';'), ';') AS UitvoerderAantal

;

SQL SELECT *

FROM mtc_rubriek

WHERE rubcode = 'PROJ_006';

LET V_MAXUITVOERDERS = MAXUITVOERDERS+1;

DROP TABLE UITVOERDERSAANTAL;

FOR i =1 to $(V_MAXUITVOERDERS)-1

LET LOOP = $(i);

//EXIT SCRIPT;

UITVOERDERS:

LOAD

SUBFIELD(REPLACE(Subfield(item_lijst,';',1), ',', ';'), ';',$(LOOP)) AS Uitvoerder,

SUBFIELD(REPLACE(item_code_lijst, ',', ';'), ';',$(LOOP)) AS Uitvoerder_Code

;

SQL SELECT *

FROM mtc_rubriek

WHERE rubcode = 'PROJ_006';

//STORE UITVOERDERS INTO Q:\Rapportages\Peter\UITVOERDER.QVD;

NEXT i

//DROP TABLE UITVOERDERSAANTAL;

EXIT SCRIPT;

BUT it doesn't work, can somebody help my with this question?

Re: Loop in QlikView SCript will not work

Peter_Cammaert — Fri, 30 Jan 2015 09:55:10 GMT

One remark:

Change your variable assignment to LET V_MAXUITVOERDERS = peek('MAXUITVOERDERS')+1;

Best,

Peter

Re: Loop in QlikView SCript will not work

marcus_sommer — Fri, 30 Jan 2015 11:11:38 GMT

I'm not quite sure what you are trying to do but I think you don't need these complex loop then by using from subfield within a load and without the third parameter it will automatically loop through these field and generate for each item a record.

- Marcus

topic Loop in QlikView SCript will not work in QlikView

Loop in QlikView SCript will not work

Re: Loop in QlikView SCript will not work

Re: Loop in QlikView SCript will not work