topic Master calendar in QlikView

Master calendar

Wed, 23 Sep 2015 06:19:41 GMT

Hie

anybody tell me about master calendar

Thank you 😉

Re: Master calendar

qlikmsg4u — Wed, 23 Sep 2015 06:24:10 GMT

Check this video and search in the community

Understanding the Master Calendar (video)

https://community.qlik.com/search.jspa?q=master+calendar

Re: Master calendar

prma7799 — Wed, 23 Sep 2015 06:25:32 GMT

Please go through below link

Understanding the Master Calendar (video)

Master Calendar with every 30 Minutes

How to use - Master-Calendar and Date-Values

Re: How to link master calendar dates to your dates in data

Thanks

Re: Master calendar

nagarjuna_kotha — Wed, 23 Sep 2015 06:29:14 GMT

See Below Script and Attached File :

LET vDateMin = Num(MakeDate(2011,2,28));

LET vDateMax = Floor(MakeDate(2011,6,15));

LET vDateToday = Num(Today());

MATCON:

LOAD

[Doc. Date],

Date(Date#([Doc. Date],'DD.MM.YYYY'),'DD/MM/YYYY') as DOC_DATE

FROM

(ooxml, embedded labels, table is matcon);

STORE MATCON into D:\Nagarjun\Test\QVD\MATCONFINALCIALCALENDER.qvd(QVD);

DROP Table MATCON ;

New:

LOAD

DOC_DATE,

Day(DOC_DATE) AS CalendarDayOfMonth,

WeekDay(DOC_DATE) AS CalendarDayName,

Month(DOC_DATE) AS CalendarMonthName,

'Q' & Ceil(Month(DOC_DATE)/3) AS CalendarQuarter,

'Q' & ceil(month(DOC_DATE)/3) as New_Qutr,

YearName(DOC_DATE,0,2) as New_Financial_Year,

'FY' & Right( Year(DOC_DATE),2) as YearQtrfy,

YearName(DOC_DATE,0,2)as FiscalYear

FROM

(qvd);

Re: Master calendar

Wed, 23 Sep 2015 06:35:06 GMT

Hi,

Go through the below links it might help u.

Master Calendar Generation Script

Master Calendar in QlikView | Learn QlikView

Creating a Master Calendar - YouTube

Re: Master calendar

krishna20 — Wed, 23 Sep 2015 07:54:27 GMT

Hi,

Hope this link will helps you.

Creating A Master Calendar

Re: Master calendar

qlikviewwizard — Wed, 23 Sep 2015 08:33:03 GMT

Hi Kanth000,

Master Calendar is a derived table by using fact table date columns or custom date values.

Please check my document here.

Master Calendar Data