Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
neetha_p
Master
Master

Master calendar generates only 31/12/1899 date issue

Hi All

Below is my master calendar script which generates only 31/12/1899,it should generate dates between 01/01/2000 to today.:

LET vMaxDate = Today();

LET vMinDate = date(Num(MakeDate(2000,1,1)));

QuarterMap:

MAPPING LOAD * INLINE [

    Month, Quarter

    7, Q3

    8, Q3

    9, Q3

    10, Q4

    11, Q4

    12, Q4

    1, Q1

    2, Q1

    3, Q1

    4, Q2

    5, Q2

    6, Q2

];

MasterCalendar:

LOAD

  Date,

  Week(Date) AS Week,

  Year(Date) AS Year,

  Month(Date) AS Month,

  Day(Date) AS Day,

  WeekDay(Date) AS WeekDay,

  applyMap('QuarterMap', num(month(Date)),'unknown qtr') AS Quarter,

  Date(monthStart(Date), 'MMM-YYYY') AS MonthYear,

  dual(Week(Date)&'-'&WeekYear(Date),WeekYear(Date) & num(Week(Date),'00')) AS WeekYear

  ;

LOAD

  Date($(vMinDate) + RecNo() - 1) AS Date

AUTOGENERATE ($(vMaxDate) - $(vMinDate)+1);

please any help will be appreciated.

Thanks

Neetha

1 Solution

Accepted Solutions
sunny_talwar

Try this:

LET vMaxDate = Num(Today());

LET vMinDate = Num(MakeDate(2000,1,1));

View solution in original post

4 Replies
sunny_talwar

Try this:

LET vMaxDate = Num(Today());

LET vMinDate = Num(MakeDate(2000,1,1));

sunny_talwar

Sample application attached.

HTH

Best,

Sunny

neetha_p
Master
Master
Author

missed that one.

Thanks for help

sunny_talwar

Not a problem

Sunny