topic Re: Master Calendar in QlikView

Master Calendar

prma7799 — Mon, 25 May 2015 06:37:59 GMT

Hi All,

I want to know what is the purpose of master calendar and why we created master calendar in the script.

Is it really need ?

Thanks

Re: Master Calendar

marcus_sommer — Mon, 25 May 2015 06:49:44 GMT

I prefer to create one but there are other opinions, too. See: Use of Master Calendar

- Marcus

Re: Master Calendar

Mon, 25 May 2015 07:14:54 GMT

Creating A Master Calendar

simply to get the data by using master Calendar like particular date,week,month,year

Re: Master Calendar

avinashelite — Mon, 25 May 2015 07:22:22 GMT

The master calender has lot of purpose with it, few are stated below:

* To build your own custom dates .

*In the normal fact table you may not have all the set of dates for a particular month and if you want on do the day to day analysis this will be helpful.

*Every organization have a different finical year and their month for finical start would be different, using master calender you can handle it better.

etc

Re: Master Calendar

PrashantSangle — Mon, 25 May 2015 07:25:02 GMT

Hi,

it depends on requirement.

Read below article written by HIC

The Master Calendar

Regards

Re: Master Calendar

Mon, 25 May 2015 08:49:38 GMT

Mostly is a matter of not having "empty dates". Say you didn't do sales the first of september, when you are going to filter, the date 01/09 won't be there, and that looks bad.

The other part is for the divisions the company may use, such as quarter, financial year, season... Those are not always common with other companies

Re: Master Calendar

buzzy996 — Mon, 25 May 2015 09:22:35 GMT

Master calendar will helps,instituted of creating multiple expression by day.month,week....month name,weekday..like many date dimensions.

u can create all those above date dimension in master calendar with in script,that helps many ways..most of the cases from the source we won't get all those fields above mentioned by creating master calender this way it helps and no need to create again & again multiple set-expression on front-end this way it helps and if we are creating multiple expressions from front end that helps loading performance both the side(server side and end user side)..like some more.