i have so many table for incidents change orders and for problems
with this i have cretaed a comman date
Requirement is I have to add hours . how to do
and the master calender script as
SUB Calendar(vField,vTable,vCal)
/*
Generic Calendar Generation script, optimised for QlikView use
*/
LET vRows=FieldValueCount('$(vField)');
IF NOT (ISNULL(vCal) OR len(vCal)=0) THEN
LET vCalNum=vCal & '.';
LET vCal=vCal & ' ';
ELSE
SET vCalNum=;
ENDIF
MinMax:
LOAD
min(tmpDate) AS minDate,
max(tmpDate) AS maxDate
WHERE tmpDate <=$(v_MaxMonthYear)
;
LOAD
FieldValue('$(vField)',recNo()) AS tmpDate
AUTOGENERATE($(vRows));
LET vMinDate=peek('minDate',0,'MinMax');
LET vMaxDate=peek('maxDate',0,'MinMax');
LET vRecs=vMaxDate-vMinDate+1;
DROP TABLE MinMax;
[$(vCal)Calendar]:
LOAD
*,
autoNumber([$(vCal)Quarter Year],'$(vCal)Quarter Year') AS [$(vCalNum)numQuarterYear],
autoNumber([$(vCal)Month Year],'$(vCal)Month Year') AS [$(vCalNum)numMonthYear],
autoNumber([$(vCal)Week Year],'$(vCal)Week Year') AS [$(vCalNum)numWeekYear]
;
LOAD
[$(vField)],
year([$(vField)]) AS [$(vCal)Year],
'Q' & ceil(month([$(vField)])/3) AS [$(vCal)Quarter],
'H' & ceil(month([$(vField)])/6) AS [$(vCal)Half],
month([$(vField)]) AS [$(vCal)Month],
num(month([$(vField)])) AS [$(vCalNum)numMonth],
week([$(vField)]) AS [$(vCal)Week],
num(week([$(vField)])) AS [$(vCalNum)numWeek],
weekDay([$(vField)]) AS [$(vCal)Weekday],
date(weekEnd([$(vField)]),'DD MMM YY') AS [$(vCal)Week Year],
date(monthStart([$(vField)]),'MMM YY') AS [$(vCal)Month Year],
dual(year([$(vField)])& ' ' & 'Q' & ceil(month([$(vField)])/3),quarterStart([$(vField)])) AS [$(vCal)Quarter Year],
if(monthStart([$(vField)])=$(ThisMonthYear),1,0) AS [$(vCal)CurrentMonthFlag],
if(weekEnd([$(vField)])=$(ThisWeekYear),1,0) AS [$(vCal)CurrentWeekFlag],
if(monthStart([$(vField)])=$(LastMonthYear),1,0) AS [$(vCal)LastMonthFlag],
if(monthStart([$(vField)],1)=$(LastMonthYear),1,0) AS [$(vCal)SecondToLastMonthFlag],
if(monthStart([$(vField)],2)=$(LastMonthYear),1,0) AS [$(vCal)ThirdToLastMonthFlag],
if(weekEnd([$(vField)])=$(LastWeekYear),1,0) AS [$(vCal)LastWeekFlag]
;
LOAD
date($(vMinDate)+recNo()-1) AS [$(vField)]
AUTOGENERATE($(vRecs));
END SUB
CALL Calendar('Date','Fact');
//CALL Calendar('Open Date','Fact','Open');Example of how unique date calendars can be created
QUALIFY *;
p1:
NoConcatenate
LOAD * RESIDENT Calendar;
p2:
NoConcatenate
LOAD * RESIDENT Calendar;
UNQUALIFY *;
how to add hours in the calender script
and aslo in the Incident date as well
