topic Re: Create a Master Calendar based on required Weekstart in QlikView

Create a Master Calendar based on required Weekstart

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

I have a Date Field Where it gives all the Dates in a year . from this date I need to derive Weeks as per the requirement .

For Every month Starting week start will be starting day of the month and for other weeks it should consider as Monday.

Example : For the month of Jan & Feb Months :

Re: Create a Master Calendar based on required Weekstart

kaushiknsolanki — Sat, 25 Apr 2020 05:30:19 GMT

Hi,

Try this.

Let vMin = Num(Makedate(2020,01,01));
Let vMax = num(Today());

Temp:
Load Date($(vMin)+RowNo()-1) as Date
AutoGenerate 1
While Date($(vMin)+RowNo()-1) <Date($(vMax));

Output:
Load Date,Weekstart(Date,0,0) as Weekstart,
If(Monthname(WeekStart(Date,0,0))<>Monthname(Date),Monthstart(Date),Weekstart(Date,0,0)) as New_WeekDay
Resident Temp;