Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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