Adapting a calendar week script

Thu, 05 Jul 2012 13:20:14 GMT

Hello all,

The below script creates a calendar week function (i.e. Week_Class = Current Week is the last full Monday-Sunday inclusive period)

I need to be able to adapt it so Week_Class = Current Week is the last full Thursday-Wednesday inclusive period.

Any ideas?

Thanks

MasterCalendar:
LOAD
 floor(TempDate) as Link_Date,
 TempDate AS mCalendarDate,
 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,
 
 
 dual(text(date(weekend(TempDate),'DD-MMM-YY')),
     if(month(weekend(TempDate))=1 and week(weekend(TempDate))=51,1,week(weekend(TempDate)))) as Nice_Week,
if(TempDate>(now()-(7)) and TempDate<(now()+1),'Previous Week') as myselector ,

TempDate as dateto,
TempDate-7 as Last_Week,

year(weekend(TempDate)) as dateto_Year,
month(TempDate) as dateto_Month,
week(weekend(TempDate)) as dateto_Week,
if(($(vDateLastWeek)-TempDate)<0,dual('Future',-1),
 if(ceil(($(vDateLastWeek)-TempDate+1)/7)=1,
      dual('Current Week',0),
          dual('Week-'&num(ceil(($(vDateLastWeek)-TempDate+1)/7)-1,'#0'),ceil(($(vDateLastWeek)-TempDate+1)/7)-1))) as Week_Class,
          
num(if(($(vDateLastWeek)-TempDate)<0,dual('Future',-1),
 if(ceil(($(vDateLastWeek)-TempDate+1)/7)=1,
      dual('Current Week',0),
          dual('Week-'&num(ceil(($(vDateLastWeek)-TempDate+1)/7)-1,'#0'),ceil(($(vDateLastWeek)-TempDate+1)/7)-1)))) as Week_ClassNum

topic Adapting a calendar week script in QlikView

Adapting a calendar week script