Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

calander

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

1 Solution

Accepted Solutions
settu_periasamy
Master III
Master III

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

];

View solution in original post

1 Reply
settu_periasamy
Master III
Master III

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

];