topic Simple For loop variable is not working in QlikView

Simple For loop variable is not working

AyCe1082 — Sat, 16 Nov 2024 00:17:24 GMT

Hi, I have a simple For loop statement that for some reason will only return one row. For this particular load there are 3 rows in the Tracker table, each with a unique ID (PK_gameId). The Fixture qvd has thousands of rows so I need to reduce it to only the rows containing IDs in the Tracker qvd.

vNumRows evaluates to 3 which is perfect. vFixtures evaluates to the unique ID in the first row. When I load the Fixture table I only get 1 row instead of 3.

Tracker: Load PK_gameId FROM [D:\QlikView\DEV\DBQVD\Soccer\ReportsTracker.qvd] (qvd) where Report_Status = 0; let vNumRows =NoOfRows('Tracker'); For i = 0 to $(vNumRows) LET vFixtures = Peek('PK_gameId',i,'Tracker'); Fixture: LOAD * FROM [D:\QlikView\LIVE\DBQVD\Soccer\db_Fixtures.qvd] (qvd) where PK_gameId = $(vFixtures);

Re: Simple For loop variable is not working

Kushal_Chawda — Tue, 21 Jul 2020 15:09:16 GMT

try below

Tracker: Load PK_gameId FROM [D:\QlikView\DEV\DBQVD\Soccer\ReportsTracker.qvd] (qvd) where Report_Status = 0; let vNumRows =NoOfRows('Tracker'); Fixture: load * inline [ Temp ]; For i = 0 to $(vNumRows) LET vFixtures = Peek('PK_gameId',i,'Tracker'); concatenate(Fixture) LOAD * FROM [D:\QlikView\LIVE\DBQVD\Soccer\db_Fixtures.qvd] (qvd) where PK_gameId = $(vFixtures); next drop field Temp;

Re: Simple For loop variable is not working

AyCe1082 — Tue, 21 Jul 2020 16:13:32 GMT

Hi Kush, that almost worked. After it loops through all the rows it doesn't end - it tries to continue looping which results in an error.

Re: Simple For loop variable is not working

Kushal_Chawda — Tue, 21 Jul 2020 16:25:54 GMT

Probably need single quotes in where condition