Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
rajkumarb
Creator II
Creator II

Week Start date change

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

0 Replies