topic Re: Nested for loop not working in QlikView

Nested for loop not working

cclayford — Fri, 03 Nov 2017 09:47:58 GMT

Hi all

I am trying to use a nested for loop in this manner:

But i keep getting this error:

Your help will be greatly appreciated.

Regards,

Christopher.

Re: Nested for loop not working

stabben23 — Fri, 03 Nov 2017 10:17:59 GMT

Hi Christopher,

if you add filelist, will that work?

for each a in filelist('586',591'......)

for each b in filelist('Prem.....)

Re: Nested for loop not working

cclayford — Fri, 03 Nov 2017 10:25:55 GMT

Unfortunately that does not work, i get this syntax error:

Re: Nested for loop not working

effinty2112 — Fri, 03 Nov 2017 10:29:57 GMT

Hi Christopher,

Try putting single quotes around your dollar sign expansions,

... comp_id = '$(a)'

...table is ['$(b)' League Table]

Regards

Andrew

PS C'mon the Gers!

Re: Nested for loop not working

stabben23 — Fri, 03 Nov 2017 10:30:40 GMT

ok, try then to add singlequote around Your variables, '$(a)' '$(b)' and delete filelist as mention above.

Re: Nested for loop not working

cclayford — Fri, 03 Nov 2017 10:41:25 GMT

Nope that gives me this error:

I can however confirm that if i load it without the "filelist" syntax, and single quotes, it does load the first comp_id, and table, but not the following ones:

Re: Nested for loop not working

stabben23 — Fri, 03 Nov 2017 10:57:49 GMT

Ok, one step further, and all URL is exactly the same except comp_id number?

Re: Nested for loop not working

cclayford — Fri, 03 Nov 2017 10:58:52 GMT

Yes that's correct.

Re: Nested for loop not working

stabben23 — Fri, 03 Nov 2017 11:05:26 GMT

ok, if you press OK, will it go on and try to load NEXT table. Click OK until Your loop is finished.

Maybe it will find some in Your interval.

Re: Nested for loop not working

cclayford — Fri, 03 Nov 2017 11:09:12 GMT

It only found the first table:

Re: Nested for loop not working

stabben23 — Fri, 03 Nov 2017 11:17:03 GMT

If you check Your variables a and b in variable overview, what values do they have?

Re: Nested for loop not working

cclayford — Fri, 03 Nov 2017 11:19:54 GMT

Re: Nested for loop not working

stabben23 — Fri, 03 Nov 2017 11:29:14 GMT

ok, so a wont loop, try to delete singlequote in the list. for each a in 586, 591 ..aso

Re: Nested for loop not working

cclayford — Fri, 03 Nov 2017 11:33:26 GMT

Unfortunately that did not work. Got the same result.

Re: Nested for loop not working

stabben23 — Fri, 03 Nov 2017 11:35:03 GMT

then delete singlequote around $(a) and still no singlequote in Your list

Re: Nested for loop not working

cclayford — Fri, 03 Nov 2017 11:39:22 GMT

The single quotes around $(a) and $(b) were already removed. If i add it, then it does not loop at all.

Re: Nested for loop not working

cclayford — Fri, 03 Nov 2017 11:42:08 GMT

I think it will be easier for you to troubleshoot with the script:

For each a in '586','591','600','594','599','593','590';

For each b in 'Premier League 17/18','Bundesliga 17/18','La Liga 17/18','French Ligue 1 17/18','Eredivisie 17/18','Serie A 2017/18','Scottish Premiership 17/18';

[Tables]:

LOAD

# as [Pos],

Clubs as [Team],

GD,

Points as [Pts],

'League Table' as [Table Type]

FROM

[https://www.statbunker.com/competitions/LeagueTable?comp_id=$(a)]

(html, codepage is 1252, embedded labels, table is [$(b) League table]);

NEXT a;

NEXT b;

Re: Nested for loop not working

stabben23 — Fri, 03 Nov 2017 11:46:26 GMT

ok, a numeric value in for each should not have any singlequotes and will be expaned without $(a).

text values should have singlequotes around as in b, this should expand With '$(b)'.

As you can see a wont loop for you, b will as it contains Scottish.

Re: Nested for loop not working

cclayford — Fri, 03 Nov 2017 12:14:02 GMT

Ok, i removed the 'a' and 'b' next to the "NEXT" function. It now loads all the tables, but it gives me errors in between:

Tables << Premier League 17/18 League table 20 Lines fetched