topic master clander in QlikView

master clander

Fri, 09 Oct 2015 14:39:39 GMT

pls share about master clander,where it is used,why it is used........

Re: master clander

miguelbraga — Fri, 09 Oct 2015 16:50:44 GMT

See this article:

https://community.qlik.com/blogs/qlikviewdesignblog/2012/10/16/the-master-calendar

Re: master clander

Anonymous — Fri, 09 Oct 2015 17:01:56 GMT

Hi Manikanta,

Master calendar is used to create Time dimension(Year/Quarter/Month/Day).

We have Standard calendar and Financial calendar,it depends on company to company which is used.

Time dimension is used to see metrics for various analysis like forecasting(Predictive analysis),whatif analysis.

Have a look:

The Master Calendar

Re: master clander

Chanty4u — Sat, 10 Oct 2015 04:12:22 GMT

Hi Mani,

Please go through below link

master calender in qlik view

Re: master clander

qlikviewwizard — Sat, 10 Oct 2015 04:41:53 GMT

Hi,

Please check this. Master Calendar Data

Re: master clander

Anonymous — Sat, 10 Oct 2015 06:01:28 GMT

Hi Mani,

Uses of Master Calendar

Re: Use of Master Calendar

Have a look:

Master Calendar Data‌

https://community.qlik.com/docs/DOC-3858

Master Calendar Generation Script‌

How to create a Calendar

Hope it helps!!

Re: master clander

jagan — Sat, 10 Oct 2015 07:26:35 GMT

Hi Manikanta,

Generally the transaction table will have only the transaction date, but in general users expect the Year, Month, Quarter, Week, dates etc to filter the data in the Dashboard, so to arrive this fields we generally use the Master Calendar with all the mentioned fields.

With master Calendar also you can generate this fields by using

LOAD

Year(TransactionDate) AS Year,

Month(TransactionDate) AS Month,

Week(TransactionDate) AS Week,

Day(TransactionDate) AS Day,

QuarterName(TransactionDate) AS Quarter

FROM DataSource;

But people generally prefer to have this fields in a separate calendar. Check below links for generating various calendars

Master Calendar Generation Script

Fiscal and Standard Calendar generation

Regards

Jagan.