topic Re: Working Days in QlikView https://community.qlik.com/t5/QlikView/Working-Days/m-p/85892#M457552 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>how about this one:</P><P></P><P><SPAN style="font-size: 13.3333px;">Calendar:</SPAN></P><P><SPAN style="font-size: 13.3333px;">load * Inline [</SPAN></P><P><SPAN style="font-size: 13.3333px;">Date</SPAN></P><P><SPAN style="font-size: 13.3333px;">2018-09-28</SPAN></P><P><SPAN style="font-size: 13.3333px;">2018-09-29</SPAN></P><P><SPAN style="font-size: 13.3333px;">2018-09-30</SPAN></P><P><SPAN style="font-size: 13.3333px;">2018-10-01</SPAN></P><P><SPAN style="font-size: 13.3333px;">2018-10-02</SPAN></P><P><SPAN style="font-size: 13.3333px;">2018-10-03</SPAN></P><P><SPAN style="font-size: 13.3333px;">2018-10-04</SPAN></P><P><SPAN style="font-size: 13.3333px;">2018-10-05</SPAN></P><P><SPAN style="font-size: 13.3333px;">2018-10-06</SPAN></P><P><SPAN style="font-size: 13.3333px;">2018-10-07</SPAN></P><P><SPAN style="font-size: 13.3333px;">2018-10-08</SPAN></P><P><SPAN style="font-size: 13.3333px;">2018-10-09</SPAN></P><P><SPAN style="font-size: 13.3333px;">2018-10-10</SPAN></P><P><SPAN style="font-size: 13.3333px;">];</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">load </SPAN></P><P><SPAN style="font-size: 13.3333px;">Date,</SPAN></P><P><SPAN style="font-size: 13.3333px;">Week(Date),</SPAN></P><P><SPAN style="font-size: 13.3333px;">Week(Date-1)</SPAN></P><P><SPAN style="font-size: 13.3333px;">Resident Calendar</SPAN></P><P><SPAN style="font-size: 13.3333px;">;</SPAN></P></BODY></HTML> Tue, 09 Oct 2018 07:59:15 GMT mtucholski 2018-10-09T07:59:15Z Working Days https://community.qlik.com/t5/QlikView/Working-Days/m-p/85887#M457547 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>any idea how to set working days / week days <SPAN style="color: #212121; font-family: Calibri, sans-serif; font-size: 14.6667px;">Tuesday to Monday, ?</SPAN></P><P><SPAN style="color: #212121; font-family: Calibri, sans-serif; font-size: 14.6667px;"><BR /></SPAN></P><P><SPAN style="color: #212121; font-family: Calibri, sans-serif; font-size: 14.6667px;">advanced thanks</SPAN></P></BODY></HTML> Tue, 09 Oct 2018 07:01:21 GMT https://community.qlik.com/t5/QlikView/Working-Days/m-p/85887#M457547 ilanbaruch 2018-10-09T07:01:21Z Re: Working Days https://community.qlik.com/t5/QlikView/Working-Days/m-p/85888#M457548 <HTML><HEAD></HEAD><BODY><P>I have no idea what you are intending to do. How about more specific description? Maybe some examples?</P><P></P><P>Help us help you.</P></BODY></HTML> Tue, 09 Oct 2018 07:07:29 GMT https://community.qlik.com/t5/QlikView/Working-Days/m-p/85888#M457548 mtucholski 2018-10-09T07:07:29Z Re: Working Days https://community.qlik.com/t5/QlikView/Working-Days/m-p/85889#M457549 <HTML><HEAD></HEAD><BODY><P>i.e</P><P>Week Number 40 in 2018 covers 10/01/208 To 10/07/2018 (Monday to Sunday).</P><P>i want to cover Tuesday to Monday 10/02/2018 To 10/08/2018 </P></BODY></HTML> Tue, 09 Oct 2018 07:22:46 GMT https://community.qlik.com/t5/QlikView/Working-Days/m-p/85889#M457549 ilanbaruch 2018-10-09T07:22:46Z Re: Working Days https://community.qlik.com/t5/QlikView/Working-Days/m-p/85890#M457550 <HTML><HEAD></HEAD><BODY><P>Have a look at</P><P></P><P><A href="https://community.qlik.com/qlik-blogpost/3545">Redefining the Week Numbers</A></P></BODY></HTML> Tue, 09 Oct 2018 07:28:43 GMT https://community.qlik.com/t5/QlikView/Working-Days/m-p/85890#M457550 swuehl 2018-10-09T07:28:43Z Re: Working Days https://community.qlik.com/t5/QlikView/Working-Days/m-p/85891#M457551 <HTML><HEAD></HEAD><BODY><P>Try setting system variable in script like:</P><P></P><P>SET FirstWeekDay=<STRONG>7</STRONG>;</P></BODY></HTML> Tue, 09 Oct 2018 07:34:30 GMT https://community.qlik.com/t5/QlikView/Working-Days/m-p/85891#M457551 tresB 2018-10-09T07:34:30Z Re: Working Days https://community.qlik.com/t5/QlikView/Working-Days/m-p/85892#M457552 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>how about this one:</P><P></P><P><SPAN style="font-size: 13.3333px;">Calendar:</SPAN></P><P><SPAN style="font-size: 13.3333px;">load * Inline [</SPAN></P><P><SPAN style="font-size: 13.3333px;">Date</SPAN></P><P><SPAN style="font-size: 13.3333px;">2018-09-28</SPAN></P><P><SPAN style="font-size: 13.3333px;">2018-09-29</SPAN></P><P><SPAN style="font-size: 13.3333px;">2018-09-30</SPAN></P><P><SPAN style="font-size: 13.3333px;">2018-10-01</SPAN></P><P><SPAN style="font-size: 13.3333px;">2018-10-02</SPAN></P><P><SPAN style="font-size: 13.3333px;">2018-10-03</SPAN></P><P><SPAN style="font-size: 13.3333px;">2018-10-04</SPAN></P><P><SPAN style="font-size: 13.3333px;">2018-10-05</SPAN></P><P><SPAN style="font-size: 13.3333px;">2018-10-06</SPAN></P><P><SPAN style="font-size: 13.3333px;">2018-10-07</SPAN></P><P><SPAN style="font-size: 13.3333px;">2018-10-08</SPAN></P><P><SPAN style="font-size: 13.3333px;">2018-10-09</SPAN></P><P><SPAN style="font-size: 13.3333px;">2018-10-10</SPAN></P><P><SPAN style="font-size: 13.3333px;">];</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">load </SPAN></P><P><SPAN style="font-size: 13.3333px;">Date,</SPAN></P><P><SPAN style="font-size: 13.3333px;">Week(Date),</SPAN></P><P><SPAN style="font-size: 13.3333px;">Week(Date-1)</SPAN></P><P><SPAN style="font-size: 13.3333px;">Resident Calendar</SPAN></P><P><SPAN style="font-size: 13.3333px;">;</SPAN></P></BODY></HTML> Tue, 09 Oct 2018 07:59:15 GMT https://community.qlik.com/t5/QlikView/Working-Days/m-p/85892#M457552 mtucholski 2018-10-09T07:59:15Z