match year month data to calendar

[sujit_nath]

I have data such that:

Range Name	Range	FYear	Financial Forecast	FQuarter	FiscalMonthName
Range1	Start	2019	fc1
Range2	Start	2019	fc1		Sep
Range3	Start	2019	fc1
Range4	Start	2019	fc1		Sep
Range5	Start	2020	fc2
Range6	Start	2020	fc2	Q4
Range7	End	2020	fc2
Range8	End	2020	fc2	Q4
Range9	End	2020	fc3
Range10	End	2020	fc3	Q4

In my master calender, I have running data, like no blanks-

fyear	FQuarter	FiscalMonthName
2020	Q1	Jan
2020	Q1	Feb
2020	Q1	Mar
2020	Q2	Apr
2020	Q2	May
2020	Q2	June

-----and so on..

How do I link my previous table to this calender?

I am bringing Financial Forecast Value in my master calender as well.

So that I can select the Range Name, and it will be linked to the master calender. My Previous table can contain blanks at places, like if quarter is mentioned, may be possible that month is not mentioned and 2020 Q4 should link accordingly in the master calender.

[Saravanan_Desingh]

Are you looking something like this?

tab1:
LOAD [Range Name], Range, FYear, [Financial Forecast]
;
LOAD * INLINE [
    Range Name, Range, FYear, Financial Forecast, FQuarter, FiscalMonthName
    Range1, Start, 2019, fc1,  ,  
    Range2, Start, 2019, fc1,  , Sep
    Range3, Start, 2019, fc1,  ,  
    Range4, Start, 2019, fc1,  , Sep
    Range5, Start, 2020, fc2,  ,  
    Range6, Start, 2020, fc2, Q4,  
    Range7, End, 2020, fc2,  ,  
    Range8, End, 2020, fc2, Q4,  
    Range9, End, 2020, fc3,  ,  
    Range10, End, 2020, fc3, Q4,  
];

Left Join(tab1)
Cal:
LOAD Year(AddMonths('1/1/2019',IterNo()-1)) As FYear
	 ,AddMonths('1/1/2019',IterNo()-1) As FDate
	 ,MonthName(AddMonths('1/1/2019',IterNo()-1)) As FiscalMonthName
	 ,QuarterName(AddMonths('1/1/2019',IterNo()-1)) As FQuarter
AutoGenerate 1
While IterNo()<=24
;

[Brett_Bleess]

If Saran's post got you what you needed, we would appreciate it if you could return to your thread and use the Accept as Solution button on their post to close the thread which will give them credit for the assist and let other Members know that worked.  

The only other thing I have is the following Design Blog post that may be of some help:

https://community.qlik.com/t5/Qlik-Design-Blog/The-Master-Calendar/ba-p/1471527

Regards,
Brett