topic Re: For - Next Loop in QlikView

For - Next Loop

Thu, 12 Feb 2015 11:14:10 GMT

Hallo,

ich habe folgende Schleife

Testtable:

LOAD ApplyMap(......) as Land,

ApplyMap(...) as Wert

From xyz where ABC = '1';

SET v1 = 'A';

SET v2 = 'B';

für 1 = 1 to 2;

Table:

Noconcatenate LOAD *

Resident Testtable where Land = '$(v$(i))';

let i = i + 1;

dropt table Testtabelle;

Warum wird meine Table nur für die Variable v1 gefüllt?

Vielen Dank

giakoum — Thu, 12 Feb 2015 11:15:17 GMT

remove i = i+1

next will do that anyway

giakoum — Thu, 12 Feb 2015 11:18:39 GMT

and please correct für 1 = 1 to 2; to for i = 1 to 2

rubenmarin — Thu, 12 Feb 2015 11:20:11 GMT

This will work if you also change:

für 1 = 1 to 2;

to:

for i = 1 to 2 //<-- No semicolon (;) here

giakoum — Thu, 12 Feb 2015 11:24:41 GMT

true

but I believe this is actually pseudo code, just for demonstration purposes.

rubenmarin — Thu, 12 Feb 2015 11:38:45 GMT

Yep, I don't think QV lets you do "for 1=1 to 2"...already tested, it's undersigned red.

Anyway I can't undertand the final question so I don't really know what's the issue.

Most probably is only the i = i+1 you said.