topic Re: Field 'a' not found in QlikView

Field 'a' not found

Anonymous — Tue, 13 Mar 2018 13:32:00 GMT

Hi,

I'm getting the following error in my Qlik load

I've searched through the script and there's no 'a' leftover anywhere. Error appears to be happening in the Master Cal script. I've attached the script below.

Anyone any ideas how to resolve it?

Thanks,

Sarah

Re: Field 'a' not found

Chanty4u — Tue, 13 Mar 2018 18:48:27 GMT

did you debug the script line by line?

check where exactly it is stopping?

even if you dont found.

each and every table put exit script and reload each table then you come to know where exactly you are wrong

Re: Field 'a' not found

jwjackso — Tue, 13 Mar 2018 20:13:28 GMT

Follow Chanty's suggestion and verify the actual values stored in varMinDate and varMaxDate

Re: Field 'a' not found

Peter_Cammaert — Tue, 13 Mar 2018 21:59:05 GMT

Before anyone can tell you how to resolve "it", we need to know what is causing this problem.

Put an

Exit Script;

right after the let varMaxDate = Peek(...); statement. Reload your document and check the content of varMinDate and varMaxDate in the Settings->Variable Overview dialog. Do they contain numerical values?

Re: Field 'a' not found

Anonymous — Wed, 14 Mar 2018 09:21:43 GMT

The error is occuring here:

TMP_Calendar:

load

$(varMinDate) + Iterno()-1 as Num,

Date($(varMinDate) + IterNo() - 1) as TempDate

AutoGenerate 1 While $(varMinDate) + IterNo() -1 <= $(varMaxDate);

Set vFM = 4 ; // First month of fiscal year

I'm using Microsoft Visual Studio so myself and a colleague can co-develop. When he reloads he doesn't get any errors and has the exact same script that I have!

Re: Field 'a' not found

Chanty4u — Wed, 14 Mar 2018 17:13:10 GMT

Basically this error will occur with the resident table not referring the exact table

kindly check the all resident table used in your script.

Re: Field 'a' not found

Margaret — Thu, 15 Nov 2018 21:23:07 GMT

I am getting the same error with a very similar script:

TempCalendar:
LOAD
$(varMinDate) + Iterno()-1 As Num,
Date($(varMinDate) + IterNo() - 1) as TempDate
AutoGenerate '1' While $(varMinDate) + IterNo()-1 <= $(varMaxDate)
;

I don't understand what should be checked about resident tables. This load statement isn't loading from a table. Its just loading from variables. I tried putting a comma after TempDate and it doesn't like it. I tried putting 'Resident [existing table name]' before the semicolon ; and it didn't like that either.

Re: Field 'a' not found

Jim — Fri, 21 Dec 2018 09:16:11 GMT

Martin_Ma, I have the same script as you. My error comes from varMinDate and varMaxDate being NULL. I checked the variables using debug mode and putting a breakpoint at TempCalendar.

Make sure that the variables are being filled.

QuartersMap:
MAPPING LOAD
rowno() as Month,
'Q' & Ceil (rowno()/3) as Quarter
AUTOGENERATE (12);

Temp:
Load
Min([Datum aangemaakt]) as minDate,
Date(Floor(Max([Datum aangemaakt]))) as maxDate
Resident Incident;

Let varMinDate = Date(Num(Peek('minDate', 0, 'Temp')));
Let varMaxDate = Date(Num(Peek('maxDate', 0, 'Temp')));
DROP Table Temp;

TempCalendar:
LOAD
$(varMinDate) + Iterno()-1 As Num,
$(varMinDate) + IterNo() - 1 as TempDate
AutoGenerate 1 While $(varMinDate) + IterNo() - 1 <= $(varMaxDate);// + 7;

Re: Field 'a' not found

natalia_sterniak — Fri, 31 Jan 2020 16:19:21 GMT

Many thanks for that!

By the way, Qlik could be more precise in error descriptions...:)

Re: Field 'a' not found

sachin961 — Fri, 19 May 2023 05:45:32 GMT

Hi,

Can you please check in TMP_Demand_Link_Table that [Data Date] has been contain any data or not .

if it is blank then it will give the 'a' filed not found.