topic Re: Date Calendar Week start change in QlikView

Date Calendar Week start change

Wed, 25 Nov 2020 16:16:04 GMT

I have created a Master Calendar as below script; but I need to do the modification as I need Start of the week should be Thursday and end of the week should be Wednesday. but as per the script below it gives me Monday to Sunday week start and week end.

can we make change like this in Qlikvew ?

LET vDateMin = Num(MakeDate(1998,1,5));
LET vDateMax = Floor(YearEnd(AddMonths(Today(), 12)));
LET vDateToday = Num(Today());
TempCalendar:
LOAD
$(vDateMin) + RowNo() - 1 AS DateNumber,
Date($(vDateMin) + RowNo() - 1) AS TempDate
AUTOGENERATE 1
WHILE $(vDateMin)+IterNo()-1<= $(vDateMax);
MasterCalendar:
LOAD
TempDate AS Go_Live_Date__c,
Month(TempDate) AS CalendarMonth,
Year(TempDate) AS CalendarYear,
WeekStart(TempDate) AS WeekStart,
WeekEnd(TempDate) AS WeekEnd,
Week(TempDate) AS Week,
Month(TempDate) & '-' & Year(TempDate) AS CalendarMonthAndYear
RESIDENT TempCalendar ORDER BY TempDate ASC;
DROP TABLE TempCalendar;

Re: Date Calendar Week start change

swuehl — Fri, 13 May 2016 13:56:44 GMT

Try

WeekStart(TempDate,0, 3) AS WeekStart,
WeekEnd(TempDate,0,3) AS WeekEnd,

Re: Date Calendar Week start change

sunny_talwar — Fri, 13 May 2016 13:57:56 GMT

Try this:

SET FirstWeekDay=3;

Re: Date Calendar Week start change

sunny_talwar — Fri, 13 May 2016 13:59:09 GMT

This would just fix the values for those two fields, wouldn't it be better to use the environmental variable to change the WeekStart day for the whole application?

Re: Date Calendar Week start change

swuehl — Fri, 13 May 2016 14:01:11 GMT

If you are using QV 11.20 or earlier, have a look at

Redefining the Week Numbers

Redefining the Week Start

For Sense or QV12:

Redefining the Week Start in Qlik Sense