Calendar WeekStart

[QlikUser_3]

Hi All,

My question is regarding weekstart():

I want my calendar week to start with 1st of the Month to first sunday of that month and last week of the month should end with monday to the last date of that month (i.e. 30th or 31st of that month).

For example:

According to below screenshot my week1 should start with 1st and end on 6th Jan. Also, week5 should start on 28th Jan and end on 31st Jan.

Thanks & Regards

[QlikUser_3 · Accepted solution]

Hi ,

Solved it by using below expression :

'week' & AutoNumber(WeekName(Date),MonthName(Date)) as MonthWeek

Thanks