Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Diff b/w Financial Calender and Master Calender?

Hi All,

Diff b/w Financial Calender and Master Calender?

Pls give me brief description.....

@Sub2u

Labels (1)
2 Replies
robert_mika
MVP
MVP

Anonymous
Not applicable
Author

Hi,

Master Calendar - A master calendar table is a dimensional table that links to a date in the data, e.g. DateField(StartDate/,EndDate/CreatedDate/OrderDate,etc...), Which does not exist in the database, Master Calendar should have standard features you'd expect in a calendaring system (like calendar and list views by Day, Week,Month, Year, Quarter, RollingMonth, FiscalMonth ,FiscalQuarter,FiscalYear,etc...). So End users have the ability to view / filter data by day, week month and year, etc...

User needs Time dimension to analyse data over the period of time(eg - month to  previous month, quarter to previous quarter, year to previous year....)

Usually Master calendar is generated for Jan to Dec,where as for Financial Calendar it varies(eg Apr -Mar or  Aug to Jul).

Financial Calendar:

A Financial Calendar( Financial year/Fiscal year/sometimes budget year)

is a period used for calculating annual ("yearly") financial statements in Companies and other organizations.

Financial years vary from Company to Company and Country to Country.

The "Financial year/Fiscal Year" may also refer to the year used for income tax reporting.

See below links:

Fiscal and Standard Calendar generation By jagan mohan

Fiscal-year   &   The-master-calendar By Henric Cronström

Regards

Neetha