Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

master calendar not linking with data


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;
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

4 Replies
Not applicable
Author

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

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
prma7799
Master III
Master III

Please share some sample file.

Not applicable
Author

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