master calendar not linking with data

[#1]

My master calendar is for some reason not linking with the data in my qvd.
Whenever I choose a month or year, the data in my charts and text objects appear as 0.

Anyone able to spot a mistake in my code?

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Database:

Load *

from [..\Apps\QVDs\database.qvd]
(qvd);

MasterCalendar:

Load Date("[$C].[Reporting Date]") AS [Reporting Month],
Year("[$C].[Reporting Date]") AS Year,
'Q'& Ceil (Month(("[$C].[Reporting Date]")) / 3) AS Quarter,
Month("[$C].[Reporting Date]") As Month;

Load
Date(MinDate + IterNo() -1 ) As "[$C].[Reporting Date]"
While (MinDate + IterNO() -1) <= Num(MaxDate);

Load
Min (Date(Date#(SubField([Reporting Month],' ',1),'MMM'),'MMM')) as MinDate,
Max (Date(Date#(SubField([Reporting Month],' ',1),'MMM'),'MMM')) as MaxDate,
Min (Date(Date#(SubField([Reporting Month],' ',2),'YYYY'),'YYYY')) as MinDate,
Max (Date(Date#(SubField([Reporting Month],' ',2),'YYYY'),'YYYY')) as MaxDate


RESIDENT Database;
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

[#2]

the mastercalendar table is linking to the database table in the table viewer. So that can't be the issue.
For some reason the "Month" and "Year" is not associating with the database table

[PrashantSangle]

can share your test qvw.

Regards,

Prashant Sangle

[prma7799]

Please share some sample file.

[#5]

unfortunately not able to upload due to work.

Would be helpful if you can spot the mistake in the code.

This is the only code that I am using.

Happy to answer add. questions to give you more insight into the code