topic Re: Master Calendar in QlikView

Master Calendar

alec1982 — Tue, 16 Feb 2016 04:16:49 GMT

hi all,

anyone has a master calendar where I can plug in a start date and end date and generate master calendar with all possible fields such as quarter, month, year, year to date..etc..

Re: Master Calendar

Anonymous — Tue, 16 Feb 2016 04:20:55 GMT

load

year(Date column) as Year,

Month(Date Column) as month,

WEEK(Date Column) as WEEK

DAY (Date Column) as DAY

'Q' & CEIL((MONTH)/3) AS QUARTER

THIS IS GENERAL CALENDAR IT USE IT OTHER WISE SEARCH IN QLIK COMMUNITY HAVE THE MASTER CALENDAR

Re: Master Calendar

settu_periasamy — Tue, 16 Feb 2016 04:22:58 GMT

Have you searched? You can get lot of Documents..

Creating A Master Calendar

QlikView script to generate a master calendar · GitHub

Re: Master Calendar

Chanty4u — Tue, 16 Feb 2016 04:27:26 GMT

SIMPLE MASTER CALENDER

The Master Calendar

Re: Master Calendar

tamilarasu — Tue, 16 Feb 2016 04:32:43 GMT

Hi,

Try the below one,

SET DateFormat='D/M/YYYY';

LET vMinDate = Num('01/01/2016');
LET vMaxDate = NUm('31/12/2016');


TempCalendar:
LOAD
  $(vMinDate) + IterNo() - 1 as Num,
  Date($(vMinDate) + IterNo() - 1) as TempDate
AutoGenerate
  1 While $(vMinDate) + IterNo() -1 <= $(vMaxDate);

MasterCalendar:
LOAD
  TempDate as Date,
  Week(TempDate) as Week,
  Year(TempDate) as Year,
  Month(TempDate) as Month,
  Day(TempDate) as Day,
  Weekday(TempDate) as WeekDay,
  'Q' & ceil(month(TempDate) / 3) as Quarter,
  'Q' & Ceil(Month(TempDate)/3) & '-' & Year(TempDate) as QuarterYear,
  MonthName(TempDate) as MonthYear,
  Week(TempDate)&'-'&Year(TempDate) as WeekYear
Resident TempCalendar
Order By TempDate ASC;

DROP Table TempCalendar;

Re: Master Calendar

Anonymous — Tue, 16 Feb 2016 05:47:52 GMT

Try the above logic

Re: Master Calendar

ramasaisaksoft — Tue, 16 Feb 2016 06:59:21 GMT

Hi Alec,

Default code for Master Calendar

Let VarMinDate = Num(Peek('OrderDate',0,'OrdersQuery'));

LET VarMaxDate = num(peek('OrderDate', -1, 'OrdersQuery'));

LET VarToday = num(Today());

TempCalendar:

LOAD

$(VarMinDate) + RowNo() -1 as DateNum,

Date($(VarMinDate) + RowNo()-1 ) as TempDate

AutoGenerate

$(VarMaxDate) - $(VarMinDate);

MasterCalendar:

LOAD

TempDate as OrderDate,

Week(TempDate) as Week,

Year (TempDate) as Year,

Month(TempDate) as Month,

Day(TempDate) as Day,

WeekDay(TempDate) as WeekDay

Resident TempCalendar;

DROP Table TempCalendar;