topic master calendar not linking with data in QlikView

master calendar not linking with data

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: master calendar not linking with data

Tue, 06 Jun 2017 10:18:43 GMT

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

Re: master calendar not linking with data

PrashantSangle — Tue, 06 Jun 2017 10:22:08 GMT

can share your test qvw.

Regards,

Prashant Sangle

Re: master calendar not linking with data

prma7799 — Tue, 06 Jun 2017 10:24:14 GMT

Please share some sample file.

Re: master calendar not linking with data

Tue, 06 Jun 2017 11:15:51 GMT

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