https://community.qlik.com/t5/QlikView/Set-Analysis-and-Multiple-Calendarss/m-p/196711#M56658 <HTML><HEAD></HEAD><BODY><P>(InWeekToDate(D, Today(), 0)*-1 as CalendarCurrWTDFlag)</P><P></P><P>=</P><P>Sum({$&lt;CalendarCurrWTDFlag={1}&gt;} price )<BR /><BR />So this basic extraction from my script and expression (in a table) shows you a basic idea of how we are trying to calculate total sales within the current week (month, year, etc).<BR /><BR />My only problem is that not until long after having built this set of scripts did I realize that the day of the week begins on Monday instead of Sunday (therefore throwing off all of our calculations.<BR /><BR />Is there an easier way to reinject the days of the week as Sunday-Saturday now that all of my work is done?</P><BR /><BR /></BODY></HTML> Mon, 04 Apr 2011 16:04:39 GMT 2011-04-04T16:04:39Z https://community.qlik.com/t5/QlikView/Set-Analysis-and-Multiple-Calendarss/m-p/196711#M56658 <HTML><HEAD></HEAD><BODY><P>(InWeekToDate(D, Today(), 0)*-1 as CalendarCurrWTDFlag)</P><P></P><P>=</P><P>Sum({$&lt;CalendarCurrWTDFlag={1}&gt;} price )<BR /><BR />So this basic extraction from my script and expression (in a table) shows you a basic idea of how we are trying to calculate total sales within the current week (month, year, etc).<BR /><BR />My only problem is that not until long after having built this set of scripts did I realize that the day of the week begins on Monday instead of Sunday (therefore throwing off all of our calculations.<BR /><BR />Is there an easier way to reinject the days of the week as Sunday-Saturday now that all of my work is done?</P><BR /><BR /></BODY></HTML> Mon, 04 Apr 2011 16:04:39 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-and-Multiple-Calendarss/m-p/196711#M56658 2011-04-04T16:04:39Z https://community.qlik.com/t5/QlikView/Set-Analysis-and-Multiple-Calendarss/m-p/196712#M56659 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>the InWeekToDate function has a 4th parameter - WeekStart - which may serve your need. (i've never used it, but by looking at the Help I think this is what you need...)</P><P></P><P>Hope this helps you.</P><P>Fernando</P></BODY></HTML> Tue, 05 Apr 2011 11:29:27 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-and-Multiple-Calendarss/m-p/196712#M56659 fosuzuki 2011-04-05T11:29:27Z