need help to add hours in c alender

qlikapple — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: need help to add hours in c alender

simospa — Mon, 03 Sep 2018 09:51:31 GMT

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

topic need help to add hours in c alender in QlikView

need help to add hours in c alender

Re: need help to add hours in c alender