calander

[#1]

Hi.

my requirement is to create master calander  and quarters from below table  i tried but if i applyed any date function it is showing blank no value iam not able to understand.. calander should be in the form of fisical year

example:

year 2013-2014---------2014-2015, Q1,Q2,Q3,Q4

if i seelect 2013 may that particular may  total expendoture should show in bar chart

[settu_periasamy · Accepted solution]

Try this in your script

Load Date as Date, 
  Date(Date,'DD/MM/YYYY' ) AS CalendarDate,
  Day(Date) AS CalendarDayOfMonth,
  WeekDay(Date) AS CalendarDayName,
  Week(Date) AS CalendarWeekOfYear,
  Month(Date) AS CalendarMonthName,
  'Q' & Ceil(Month(Date)/3) AS CalendarQuarter,
  'W' & Ceil(Week(Date)/8) as Fiscalweek,
  Year(Date) AS CalendarYear,
  MonthName(Date) as CalendarMonthAndYear,
  Month(Date)&' '& YearName(Date,0,2)as FiscalYear,
  'Q' & Ceil(Month(Date)/3) & '/' & Year(Date) AS CalendarQuarterYear,
  Year(Date) & '/' & 'Q' & Ceil(Month(Date)/3) AS CalendarYearQuarter;


LOAD Distinct Date(Floor(Date#(pay_yearmonth, 'D/M/YYYY hh:mm')),'D/M/YYYY') as Date;


LOAD * INLINE [
    pay_yearmonth
    1/1/2013 0:00
    1/1/2014 0:00
    1/1/2015 0:00
    2/1/2013 0:00
    2/1/2014 0:00
    2/1/2015 0:00
    3/1/2013 0:00
    3/1/2014 0:00
    3/1/2015 0:00
    4/1/2013 0:00
    4/1/2014 0:00
    5/1/2013 0:00
    5/1/2014 0:00
    6/1/2013 0:00
    6/1/2014 0:00
    7/1/2013 0:00
    7/1/2014 0:00
    8/1/2013 0:00
    8/1/2014 0:00
    9/1/2013 0:00
    9/1/2014 0:00
    10/1/2013 0:00
    10/1/2014 0:00
    11/1/2013 0:00
    11/1/2014 0:00
    12/1/2013 0:00
    12/1/2014 0:00
];