Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

roisolberg
New Contributor III

Master Calendar error: "Field '<=' not found "

Hi All,

 

I encountered an odd error,

when loading my master calendar i receive an error "Field '<=' not found "

the weird thing is that i am using the same calendar in several models and it works fine.

i have searched the community and saw suggestions of changing the order of the script but it does not seem to work.

 

any ideas?

FieldNotFound.JPG

2 Solutions

Accepted Solutions
Partner
Partner

Re: Master Calendar error: "Field '<=' not found "

Hi
Looks like your max date variable is not being populated for some reason.
Add a trace statement after the lets.

Trace max date $(vMAxDate);
When you run the script you should see the value in the variable.

Mark

Re: Master Calendar error: "Field '<=' not found "

If you look closely, your FactEntities table have fetched 0 records and minmaxdate is blank...

image.png

Since, there is no row in minmaxdate... the variables are empty. You need to figure out what is going on with you minmaxdate table or even better would be to check FactEntities table.

3 Replies
Partner
Partner

Re: Master Calendar error: "Field '<=' not found "

Hi
Looks like your max date variable is not being populated for some reason.
Add a trace statement after the lets.

Trace max date $(vMAxDate);
When you run the script you should see the value in the variable.

Mark

Re: Master Calendar error: "Field '<=' not found "

If you look closely, your FactEntities table have fetched 0 records and minmaxdate is blank...

image.png

Since, there is no row in minmaxdate... the variables are empty. You need to figure out what is going on with you minmaxdate table or even better would be to check FactEntities table.

Highlighted
roisolberg
New Contributor III

Re: Master Calendar error: "Field '<=' not found "

Thanks guys

you were right 🙂