Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
did you try the solutions indicated in these posts?
Question about adding time into my master calendar
Let us know.
Simone