Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
roisolberg
Creator
Creator

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

Labels (3)
2 Solutions

Accepted Solutions
mark6505
Partner - Specialist III
Partner - Specialist III

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

View solution in original post

sunny_talwar

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.

View solution in original post

3 Replies
mark6505
Partner - Specialist III
Partner - Specialist III

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
sunny_talwar

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.

roisolberg
Creator
Creator
Author

Thanks guys

you were right 🙂