Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
QlikUser_3
Partner - Contributor
Partner - Contributor

Calendar WeekStart

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.

Cal.PNG

Thanks & Regards

Labels (3)
1 Solution

Accepted Solutions
QlikUser_3
Partner - Contributor
Partner - Contributor
Author

Hi ,

Solved it by using below expression :

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

Thanks

View solution in original post

1 Reply
QlikUser_3
Partner - Contributor
Partner - Contributor
Author

Hi ,

Solved it by using below expression :

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

Thanks