This content has been marked as final.
Show 5 replies

Re: Formula to calculate the week start date with Monday as beginning of week.
chaitanya yelisetty Mar 21, 2018 1:28 PM (in response to Deborah Levin)Can you try resetting the below setting in Load Script Editor in QlikSense.
Default:
SET FirstWeekDay=6;
Change to SET FirstWeekDay=1;(i think 0 or 1 try)?
Thanks
CY

Re: Formula to calculate the week start date with Monday as beginning of week.
Jahanzeb Hashmi Mar 21, 2018 2:29 PM (in response to Deborah Levin)you can use WeekStart(date [, period_no = 0 [, first_week_day=0]])

Re: Formula to calculate the week start date with Monday as beginning of week.
Jahanzeb Hashmi Mar 21, 2018 2:30 PM (in response to Jahanzeb Hashmi)weekstart('12/01/2013') Returns 07/01/2013. weekstart('12/01/2013', 1 ) Returns 31/11/2012. weekstart('12/01/2013', 0, 1) Returns 08/01/2013. 
Re: Formula to calculate the week start date with Monday as beginning of week.
Deborah Levin Mar 21, 2018 3:30 PM (in response to Jahanzeb Hashmi)I am confused how this formula would take a date, such as 02/09/2018, and return a week start date of 02/05/2018.

Re: Formula to calculate the week start date with Monday as beginning of week.
Jahanzeb Hashmi Mar 21, 2018 3:41 PM (in response to Deborah Levin)as it is it should return the 02/05/2018
huuu
ok try this
WeekStart('02/09/2018',0,0)


