Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a master calendder in my script,from week1 ,i need to change the calender which shows from saturday to next friday , can any one please help, my server is based on US
please find the master calender which have now in qlikview.
The OPEN_DATE is in epoch format,
tables:
floor(num(Timestamp('1970-01-01 00:00:00.000') + (OPEN_DATE)/60/60/24)) as IN_ST_OPEN_DATE,
id
from table;
Temp:
Load
Min(IN_ST_OPEN_DATE) as minDate,
MonthEnd( Max(IN_ST_OPEN_DATE)) as maxDate
Resident tables;
Let varMinDate = Num(Peek('minDate', 0, 'Temp'));
Let varMaxDate = Num(Peek('maxDate', -1, 'Temp'));
DROP Table Temp;
TempCalendar:
LOAD
$(varMinDate) + Iterno()-1 As Num,
Date($(varMinDate) + IterNo() - 1) as TempDate
AutoGenerate 1 While $(varMinDate) + IterNo() -1 <= $(varMaxDate);
MasterCalendar:
Load
floor(num(TempDate)) AS IN_ST_OPEN_DATE,
week(TempDate) As Week,
Year(TempDate) As Year,
Month(TempDate) As Month,
Day(TempDate) As Day,
Week(weekstart(TempDate)) & '-' & WeekYear(TempDate) as WeekYear,
//WeekDay(TempDate) as WeekDay,
MonthName(TempDate) as MonthName,
Num(Month(TempDate)) as MonthNum
//if(month(weekend(TempDate))= month(TempDate),div(day(WeekEnd(TempDate)),7),div(day(Weekend(TempDate,-1)),7)+1)+1 as MonthWeekNumber
Resident TempCalendar
Order By TempDate ASC;
Drop Table TempCalendar;
//Left join (MasterCalendar)
//Load IN_ST_OPEN_DATE, Num(Month(IN_ST_OPEN_DATE)) as MonthNum
//Resident MasterCalendar;
i want to show the