Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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');
Sorry I attached wrong qvw. This is the updated one.
Please finf it and help me out from this
Hi Andrey,
Now i attached one qvw please check that and based on that please give the suggestion
Thank you in advance
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
The field CanonicalDate is empty, therefore mindate and maxdate for mastercaledar are null. Check creating [DateBridge] table and applymap() statement.
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 this
I am attaching qvw also please check it and let me know what was the mistake
Check Andreys answer.
Indeed your CanonicalDate Field is empty!
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
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