Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Field not found master calendar problem

Hi guys, i have a problem with the creation of master calendar. I read a lot of post on this argument but i didn't find any solution. When i try to connect my table date to the master calendar's script, it says me : field not found. I work in a database on ODBC with a lot of datas and tables.

I really like to know what does it mean and why qlik give me this error and what i have to do to solve this.

This is an example of my data:

 

 

2 Replies
Highlighted
Creator II
Creator II

Hi,

Fields in Qlik Sense are case-sensitive. DateID is not equal to DateId.

See the corrected script in the attached app. 

If it is what you are looking for, consider marking this answer as resolved.

Regards,

Chirag

Highlighted
Contributor II
Contributor II

I tried to change my code as u say and now it works.

I have an other question about the function unqualify. I tried with an other master calendar's script found here: https://community.qlik.com/t5/QlikView-Scripting/Creating-A-Master-Calendar/td-p/341286

I unlink some key using function unqualify because of the large amount of data and because i have duplicated datafield on different table. Then i try to use the calendar's script. I got the error field 'a' not found. After a lot of try i found that if i don't use the unqualify function the script don't works (and it keeps say field 'a' not found). Can you explain me why?