I am facing this issue in master calender

ss2q — Thu, 29 Feb 2024 10:22:45 GMT

Hi everyone

I made a master calendar but the issue is it does not link it with the year of the master calender with the year of Gl year in the Invoice table and then I again created the year of the master calendar with the year of ordered date in the Order table. In the script, I just created the table but when I create the relation in the data manager it gives me this issue. I have separated the year from both tables in their tables also. I want my analysis to use GLdates year to show results so when I choose any year for example 2020 it shows pick the same year from the order date alos and show result.

This is my code in the load script.

// Create a master calendar based on GL_DATE
MasterCalendar:
LOAD
Date(GL_DATE) AS Date,
Year(GL_DATE) AS Year,
Month(GL_DATE) AS Month
Resident XX_INVOICE_GL_MV_TRIMMED;

I will be grateful if someone can help me fix it

Re: I am facing this issue in master calender

Clement15 — Thu, 29 Feb 2024 13:52:56 GMT

Hello, could this be suitable?
Solved: Link 2 Date Fields in 1 Table to 1 Master Calendar - Qlik Community - 84165

topic Re: I am facing this issue in master calender in Featured Members

I am facing this issue in master calender

Re: I am facing this issue in master calender