topic Re: Qlik Sense Script Line Error on For Loop in Version 2.2.0 in App Development

Qlik Sense Script Line Error on For Loop in Version 2.2.0

TKendrick20 — Wed, 23 Mar 2016 23:40:41 GMT

I have a script that used to work with previous versions and definitely worked in QlikView:

[tmpTable]:
Generic Load * Resident [Demographic Responses];

[Demographic Information]:
Load Distinct [Respondent ID] as [Respondent ID]
Resident [Demographic Responses];

FOR i = 0 to NoOfTables()
TableList:
  Load TableName($(i)) as [TableName] AUTOGENERATE 1
  WHERE WildMatch (TableName($(i)), 'tmpTable.*');
NEXT i

FOR i = 1 to FieldValueCount('Tablename')
  LET vTable = FieldValue('Tablename', $(i));
  LEFT JOIN ('Demographic Information') LOAD * RESIDENT [$(vTable)];
  DROP TABLE [$(vTable)];
NEXT i

Drop Tables [Demographic Responses], TableList;

The first For loop works, but the second does not for some reason. I assure you there is NO problem with the data in [Demographic Responses]. I've tried other types of loops and I am out of ideas. I get the following error every time:

Re: Qlik Sense Script Line Error on For Loop in Version 2.2.0

Gysbert_Wassenaar — Thu, 24 Mar 2016 07:03:09 GMT

Load TableName($(i)) as [TableName] AUTOGENERATE 1

FOR i = 1 to FieldValueCount('Tablename')

TableName and Tablename are two different fields. So, just a typo.

Re: Qlik Sense Script Line Error on For Loop in Version 2.2.0

Chanty4u — Thu, 24 Mar 2016 08:24:07 GMT

Missing Capital "N" in ur TableName

u shud use the same fieldnames or table names same for entire document.

Re: Qlik Sense Script Line Error on For Loop in Version 2.2.0

TKendrick20 — Thu, 24 Mar 2016 13:17:48 GMT

That has been corrected, still the same error. I was testing a bunch of different things which is why that mistake is in the original question. I have also tried:

While -> Loop instead of For -> Next
Doing "FieldValueCount('Tablename') STEP 1"
The table names include spaces which I replaced with "_"

In debugging I'm seeing some weird things happen where the variable "i" is exceeding the actual count of field values and then the loop is breaking. I'll keep at it

Re: Qlik Sense Script Line Error on For Loop in Version 2.2.0

Gysbert_Wassenaar — Thu, 24 Mar 2016 13:34:29 GMT

I saw you read another similar discussion. Did you enable the legacy mode as mentioned in that discussion?

Re: Qlik Sense Script Line Error on For Loop in Version 2.2.0

TKendrick20 — Thu, 24 Mar 2016 13:39:13 GMT

I have not. This is Qlik Sense server I'm working on. Does it still work with that?

Re: Qlik Sense Script Line Error on For Loop in Version 2.2.0

Gysbert_Wassenaar — Thu, 24 Mar 2016 13:48:14 GMT

Yes, unfortunately it's a server wide setting. And it has security implications so this is not a step to take lightly. See Qlik Sense Legacy mode for more information.