Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
bvssudhakar
Creator III
Creator III

Master Calendar "Field not found" Error

Hi Experts,

I am trying to create Canonical Date Almost all i have completed successfully but when I am trying to create the master calendar for Canonical Date column I am getting this error

Capture.JPG

Can you guys please check the qvw and help me out from this, Why i am getting this error and what is my mistake

Thank you in advance

19 Replies
andrey_krylov
Specialist
Specialist

Try this one

LOAD Date('2016-01-01' + IterNo() - 1) as [Date] AutoGenerate 1 While Date('2016-01-01' + IterNo() - 1) <= Date('2020-01-01');

bvssudhakar
Creator III
Creator III
Author

Sorry I attached wrong qvw. This is the updated one.

Please finf it and help me out from this

bvssudhakar
Creator III
Creator III
Author

Hi Andrey,

Now i attached one qvw please check that and based on that please give the suggestion

Thank you in advance

Frank_Hartmann
Master II
Master II

Replace this on all Tabs:

Load

  $(vMinDate) + IterNo() - 1 as DateNum

AutoGenerate 1

While $(vMinDate) + IterNo() - 1 <= $(vMaxDate);

with this

Load

  '$(vMinDate)' + IterNo() - 1 as DateNum

AutoGenerate 1

While '$(vMinDate)' + IterNo() - 1 <= '$(vMaxDate)';

hope this helps

andrey_krylov
Specialist
Specialist

The field CanonicalDate  is empty, therefore mindate  and maxdate for mastercaledar are null. Check creating [DateBridge] table and applymap() statement.

bvssudhakar
Creator III
Creator III
Author

Hi Frank,

I have replaced with this in my qvw but when i am trying to create master calendar year i am getting empty like thisCapture2.JPG

I am attaching qvw also please check it and let me know what was the mistake

Frank_Hartmann
Master II
Master II

Check Andreys answer.

Indeed your CanonicalDate  Field is empty!

bvssudhakar
Creator III
Creator III
Author

Yeah, I have verified that also. But i am not getting any clue why my Canonical Date Field is empty.

Can you guys please help me out from this

bvssudhakar
Creator III
Creator III
Author

Yeah, I have verified But i am not getting any clue why my Canonical Date Field is empty.

Can you guys please help me out from this