First time poster here in the community. I have the following script I'm trying to use, but I keep getting the Field Not Found error. I can't seem to find the issue here, but it does appear to be in my MasterCalendar table. Any help would be appreciated.
LET vMinDate = NUM(MAKEDATE(1900,1,1));
LET vMaxDate = NUM(MAKEDATE(2999,12,31));
$(vMinDate) + ITERNO() - 1 AS DateID,
DATE($(vMindate) + ITERNO() - 1) AS TempDate
AUTOGENERATE 1 WHILE $(vMinDate) + ITERNO() - 1 <= $(vMaxDate);
I just copy-pasted the above code in an empty QlikView application and run the script.
I do not get any errors.
My assumption is that you have more code in your script than the part you are showing here and that the problem actually is caused there.
If I have this happen in my regular QlikView Developer class, I would go look at the previous page of your script as I assume you are using "QUALIFY *;" somewhere in your script and forgot to close it with an "UNQUALIFY *;".
Thanks guys for your support! I was actually able to fix my issue by just changing the order of how things ran for some strange reason. For example, I had a database connection bringing in a couple of tables, then an excel spreadsheet load, and then the master calendar code. I did look over all of it and checked for the things you all mentioned and nothing. I ended up running my master calendar code first in the sequence and for whatever reason that fixed it. Appreciate the responses.