topic Re: Closed weeks in QlikView https://community.qlik.com/t5/QlikView/Closed-weeks/m-p/26327#M4380 <HTML><HEAD></HEAD><BODY><P>What is a closed week? Do you mean last 8 completed weeks? What is the last day of week for you? Saturday or Sunday?</P></BODY></HTML> Tue, 03 Apr 2018 15:33:34 GMT sunny_talwar 2018-04-03T15:33:34Z Closed weeks https://community.qlik.com/t5/QlikView/Closed-weeks/m-p/26326#M4379 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 8pt;">Hello, </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Can you please tell me how can i get in QlikView the last 8 closed weeks?(maybe from variables) For example today is Wednesday 28-03-201 and this is not a closed week.&nbsp; I have to show only the closed ones. </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Thanks,</SPAN></P><P><SPAN style="font-size: 8pt;">D</SPAN></P></BODY></HTML> Wed, 28 Mar 2018 15:29:07 GMT https://community.qlik.com/t5/QlikView/Closed-weeks/m-p/26326#M4379 diordache10 2018-03-28T15:29:07Z Re: Closed weeks https://community.qlik.com/t5/QlikView/Closed-weeks/m-p/26327#M4380 <HTML><HEAD></HEAD><BODY><P>What is a closed week? Do you mean last 8 completed weeks? What is the last day of week for you? Saturday or Sunday?</P></BODY></HTML> Tue, 03 Apr 2018 15:33:34 GMT https://community.qlik.com/t5/QlikView/Closed-weeks/m-p/26327#M4380 sunny_talwar 2018-04-03T15:33:34Z Re: Closed weeks https://community.qlik.com/t5/QlikView/Closed-weeks/m-p/26328#M4381 <HTML><HEAD></HEAD><BODY><P>Maybe something like</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_15227847188998436 jive_text_macro" jivemacro_uid="_15227847188998436"> <P>Date&gt;=WeekStart(Today()+1,-8)</P> </PRE><P></P><P>hope this helps</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Tue, 03 Apr 2018 19:45:23 GMT https://community.qlik.com/t5/QlikView/Closed-weeks/m-p/26328#M4381 MarcoWedel 2018-04-03T19:45:23Z