Week Start date change

rajkumarb — Mon, 26 Jan 2015 12:18:37 GMT

HI Experts

I have a Scenario in my sales table my branch working days starts from Saturday and end on Friday, and my sales per week is calculated according to that, my question is if i select Jan 2015 1st Week should only show 01/01/2015 and 20/01/2015 but instead it showing 2nd & 3rd, here with this i attached the file also,

I Used the same

Set vCal_FD = 6;

and

Dual( WeekDay( Date ), Mod( WeekDay( Date - $(vCal_FD) ), 7 ) +1 ) as WeekDay

from Redefining the Week Start Article

in my Mastercalendar but the values are not changing Please Help

topic Week Start date change in QlikView

Week Start date change