Week Calculation

[manojkulkarni]

Hi Friends,

I am working on making some weekly report where in i have to consider Saturday as Weekstart & Friday as weekend for calculation. I am trying by setting FirstWeekDay in Script. But i am not able to the required result. Please advise

[manojkulkarni]

=(WeekStart(Today())) is returning 21-08-2017 where as Saturday is 19-08-2017

[Anil_Babu_Samineni]

Try this in your environment

SET DayNames='Sat;Sun;Mon;Tue;Wed;Thu;Fri';

[prma7799]

Hi Manoj ,

Your script is ok.

Instead of this WeekStart(Today()) try this function WeekDay(WeekStart(Today()))

[qlikviewwizard]

This is working for me:

=WeekDay(WeekStart(Today()))

=WeekDay(WeekEnd(Today()))

[manojkulkarni]

I agree, by using weekday() function it is returning the value. But i would need the weekstart & end dates for my calculation.

[chris_johnson]

If I'm reading it right you may just need to change the line of script where it says:

SET FirstWeekDay=0;

to

SET FirstWeekDay=5;