Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
bvssudhakar
Contributor 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
andrey_krylov
Valued Contributor

Re: Master Calendar "Field not found" Error

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
Contributor II

Re: Master Calendar "Field not found" Error

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

Please finf it and help me out from this

bvssudhakar
Contributor II

Re: Master Calendar "Field not found" Error

Hi Andrey,

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

Thank you in advance

Frank_Hartmann
Honored Contributor II

Re: Master Calendar "Field not found" Error

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
Valued Contributor

Re: Master Calendar "Field not found" Error

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

bvssudhakar
Contributor II

Re: Master Calendar "Field not found" Error

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
Honored Contributor II

Re: Master Calendar "Field not found" Error

Check Andreys answer.

Indeed your CanonicalDate  Field is empty!

bvssudhakar
Contributor II

Re: Master Calendar "Field not found" Error

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
Contributor II

Re: Master Calendar "Field not found" Error

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