topic calendar automatically generation in QlikView

calendar automatically generation

Tue, 17 Aug 2010 10:12:03 GMT

Hi,

I want to add a time dimension and i don't know how to generate automatically a calendar on Qlikview with a min and max date?

Yours faithfully

calendar automatically generation

Tue, 17 Aug 2010 12:35:07 GMT

use this set minyear=2009; set maxyear=2010; for i=$(minyear) to $(maxyear) CalendarRaw: load date(makedate($(i))+recno()-1,'DD-MM-YYYY') as Calendar autogenerate 365; next i Hope this will solve the problem

calendar automatically generation

Tue, 17 Aug 2010 12:43:12 GMT

I find this :

LET

vDateMin = Num(MakeDate(2000,1,1));

LET

vDateMax = Floor(YearEnd(AddMonths(Today(), 12)));

LET

vDateToday = Num(Today());

TempCalendar:

LOAD

$(vDateMin)

+ RowNo() - 1 AS DateNumber

Date

($(vDateMin) + RowNo() - 1) AS TempDate

AUTOGENERATE

WHILE

$(vDateMin)+IterNo()-1<= $(vDateMax);

MasterCalendar:

LOAD

TempDate

AS CalendarDate

Day

(TempDate) AS CalendarDay

WeekDay

(TempDate) AS CalendarWeekDay

Week

(TempDate) AS CalendarWeek

Month

(TempDate) AS CalendarMonth

Year

(TempDate) AS CalendarYear

'Q'

& Ceil(Month(TempDate)/3) AS CalendarQuarter

WeekDay

(TempDate) & '-' & Year(TempDate) AS CalendarWeekAndYear

Month

(TempDate) & '-' & Year(TempDate) AS CalendarMonthAndYear

RESIDENT

TempCalendar ORDER BY TempDate ASC;

DROP

TABLE

TempCalendar;

LET

vDateMin = Num(MakeDate(2000,1,1));

LET

vDateMax = Floor(YearEnd(AddMonths(Today(), 12)));

LET

vDateToday = Num(Today())

;

calendar automatically generation

Tue, 17 Aug 2010 12:47:10 GMT

Hi,

Maybe the following code could help you:


Set Init_Date= Date('01/01/2000', 'DD/MM/YYYY');
Set Final_Date = Date('31/12/2002', 'DD/MM/YYYY');
Calendar:
 load Date($(Init_Date) - 1 + RecNo(), 'DD/MM/YYYY') as Date
 autogenerate ($(Final_Date) - $(Init_Date) + 1);

Regards.