Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor

master calender from saturday to friday

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

 

 

 

1 Reply
Highlighted
Partner
Partner

Re: master calender from saturday to friday

try this
'Wk ' & Day(WeekStart(today())-1) &'-' & Date(WeekEnd(today())-1,'dd MMM')

this returns Wk 30-05 Apr for today