need help to add hours in c alender

[qlikapple]

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

[simospa]

Hi,

did you try the solutions indicated in these posts?

Master Calendar With Hour

Master calendar with hour

Question about adding time into my master calendar

Let us know.

Simone