QlikView Tratamento #(Datas/Calendário)

Ĉ¿

Este script abaixo fornece a informação completa sobre o calendário. 

Calendário:

LET vDateMin = Num(MakeDate(2009,1,1)); 
LET vDateMax = Floor(MonthEnd(Today())); 
LET vDateToday = Num(Today()); 

TempCalendar: 
LOAD
$(vDateMin) + RowNo() - 1 AS DateNumber, 
Date($(vDateMin) + RowNo() - 1) AS TempDate 
AUTOGENERATE 1 
WHILE $(vDateMin)+IterNo()-1<= $(vDateMax); 

Calendar: 
LOAD
Date(TempDate) AS CalendarDate, 

// Padrão Data 
Day(TempDate) AS CalendarDayOfMonth, 
WeekDay(TempDate) AS CalendarDayName, 
Week(TempDate) AS CalendarWeekOfYear, 
Month(TempDate) AS CalendarMonthName, 
'Q' & Ceil(Month(TempDate)/3) AS CalendarQuarter, 
Year(TempDate) AS CalendarYear, 

// Calendário da por nome
WeekName(TempDate) as CalendarWeekNumberAndYear, 
MonthName(TempDate) as CalendarMonthAndYear, 
QuarterName(TempDate) as CalendarQuarterMonthsAndYear, 

// Datas de início
DayStart(TempDate) as CalendarDayStart, 
WeekStart(TempDate) as CalendarWeekStart, 
MonthStart(TempDate) as CalendarMonthStart, 
QuarterStart(TempDate) as CalendarQuarterStart, 
YearStart(TempDate) as CalendarYearStart, 

// Datas Finais
DayEnd(TempDate) as CalendarDayEnd, 
WeekEnd(TempDate) as CalendarWeekEnd, 
MonthEnd(TempDate) as CalendarMonthEnd, 
QuarterEnd(TempDate) as CalendarQuarterEnd, 
YearEnd(TempDate) as CalendarYearEnd, 

// Exemplos em conjunto 
'Q' & Ceil(Month(TempDate)/3) & '/' & Year(TempDate) AS CalendarQuarterAndYear, 
Year(TempDate) & '/' & 'Q' & Ceil(Month(TempDate)/3) AS CalendarYearAndQuarter, 
'Wed ' & DayStart(WeekStart(TempDate) + 3) as CalendarWednesdays 

RESIDENT TempCalendar ORDER BY TempDate ASC; 

DROP TABLE TempCalendar; 


Duvidas de como utilizar, poste seu comentário abaixo.






fonte: http://qlikviewsolutions.blogspot.com.br/