Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

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
Highlighted
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');

Highlighted
Creator II
Creator II

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

Please finf it and help me out from this

Highlighted
Creator II
Creator II

Hi Andrey,

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

Thank you in advance

Highlighted
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

Highlighted
Specialist
Specialist

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

Highlighted
Creator II
Creator II

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

Highlighted
Master II
Master II

Check Andreys answer.

Indeed your CanonicalDate  Field is empty!

Highlighted
Creator II
Creator II

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

Highlighted
Creator II
Creator II

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