calender

[#1]

hi.,

i want to chosse weeks from a month.for ge:if i chosse feb it should drill down to week1,week2,wee3,wee4 likewise for every month

[ashfaq_haseeb]

Hi,

Try the below script.

Let varMinDate = num(MakeDate(2000,1,1));
Let varMaxDate = num(MakeDate(2020,12,31));


//*************** Temporary Calendar ***************
TempCalendar:
LOAD 
  $(varMinDate) + rowno() - 1 AS Num, 
  date($(varMinDate) + rowno() - 1) AS TempDate 
AUTOGENERATE 
  $(varMaxDate) - $(varMinDate) + 1; 




//*************** Master Calendar ***************
MasterCalendar:
LOAD TempDate AS RA_Date,
  Week(TempDate) AS RA_Week,
// year(TRANSACTION_DATE) as TRANSACTION_Year,
//     Month(TRANSACTION_DATE) as TRANSACTION_MONTH,
//     Week(TRANSACTION_DATE) as TRANSACTION_WEEK,
//     Year(TRANSACTION_DATE)&Week(TRANSACTION_DATE) as TRANSACTION_YEARWEEK_NUM, 
  Year(TempDate) AS RA_Year,
  Month(TempDate) AS RA_Month,
  Day(TempDate) AS RA_Day,
  Year(TempDate)&Week(TempDate) as RA_YEARWEEK_NUM, 
  'Q'&ceil(month(TempDate)/3) AS Quarter

RESIDENT TempCalendar 
ORDER BY TempDate ASC;


DROP TABLE TempCalendar;
Store MasterCalendar into MasterCalendar.qvd(qvd);

Regards

ASHFAQ

[preminqlik]

calendar:

Load *,

if(match(Day,1,2,3,4,5,6,7),dual(1,'Week1'),

if(match(Day,8,9,10,11,12,13,14),dual(2,'Week2'),

if(match(Day,15,16,17,18,19,20,21),dual(3,'Week3'),dual(4,'Week4'))))               as               WeekNew

resident path;