topic Re: Master calendar generates only 31/12/1899 date issue in QlikView

Master calendar generates only 31/12/1899 date issue

Anonymous — Mon, 20 Jul 2015 14:27:03 GMT

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

Re: Master calendar generates only 31/12/1899 date issue

sunny_talwar — Mon, 20 Jul 2015 14:31:50 GMT

Try this:

LET vMaxDate = Num(Today());

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

Re: Master calendar generates only 31/12/1899 date issue

sunny_talwar — Mon, 20 Jul 2015 14:34:50 GMT

Sample application attached.

HTH

Best,

Sunny

Re: Master calendar generates only 31/12/1899 date issue

Anonymous — Mon, 20 Jul 2015 14:35:05 GMT

missed that one.

Thanks for help

Re: Master calendar generates only 31/12/1899 date issue

sunny_talwar — Mon, 20 Jul 2015 14:35:39 GMT

Not a problem

Sunny