topic Calculate weekly closures in Qlik Learning Discussions https://community.qlik.com/t5/Qlik-Learning-Discussions/Calculate-weekly-closures/m-p/779615#M2028 <HTML><HEAD></HEAD><BODY><P>Hi I am looking for some help on below. Scenario is that I want to capture weekly closures. I have data and desired output as per attached can you please throw some ideas.</P><P>Thanks</P><P>Mahesh</P></BODY></HTML> Wed, 11 Mar 2015 09:51:44 GMT 2015-03-11T09:51:44Z Calculate weekly closures https://community.qlik.com/t5/Qlik-Learning-Discussions/Calculate-weekly-closures/m-p/779615#M2028 <HTML><HEAD></HEAD><BODY><P>Hi I am looking for some help on below. Scenario is that I want to capture weekly closures. I have data and desired output as per attached can you please throw some ideas.</P><P>Thanks</P><P>Mahesh</P></BODY></HTML> Wed, 11 Mar 2015 09:51:44 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/Calculate-weekly-closures/m-p/779615#M2028 2015-03-11T09:51:44Z Re: Calculate weekly closures https://community.qlik.com/t5/Qlik-Learning-Discussions/Calculate-weekly-closures/m-p/779616#M2029 <HTML><HEAD></HEAD><BODY><P>See attached qvw.</P></BODY></HTML> Wed, 11 Mar 2015 17:39:43 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/Calculate-weekly-closures/m-p/779616#M2029 Gysbert_Wassenaar 2015-03-11T17:39:43Z Re: Calculate weekly closures https://community.qlik.com/t5/Qlik-Learning-Discussions/Calculate-weekly-closures/m-p/779617#M2030 <HTML><HEAD></HEAD><BODY><P><EM>LOAD</EM></P><P><EM>&nbsp; Date, </EM></P><P><EM>&nbsp;&nbsp;&nbsp;&nbsp; Status</EM></P><P><EM>FROM</EM></P><P><EM>Example.xlsx</EM></P><P><EM>(ooxml, embedded labels, table is Sheet1);</EM></P><P></P><P>dimension&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =pick(match (week(Today()) - Week(Date),0,1,2,3), 'Current', 'PW', 'PPW', 'PPPW')</P><P>expression&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; count({$ &lt;Status={Closed}&gt;} Status)</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; count({$ &lt;Status={Open}&gt;} Status)</P><P></P><P><IMG alt="1.jpg" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/80495_1.jpg" style="height: auto; width: auto;" /></P></BODY></HTML> Wed, 11 Mar 2015 19:09:41 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/Calculate-weekly-closures/m-p/779617#M2030 maxgro 2015-03-11T19:09:41Z Re: Calculate weekly closures https://community.qlik.com/t5/Qlik-Learning-Discussions/Calculate-weekly-closures/m-p/779618#M2031 <HTML><HEAD></HEAD><BODY><P>Thank you guys for the idea</P></BODY></HTML> Fri, 13 Mar 2015 07:51:36 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/Calculate-weekly-closures/m-p/779618#M2031 2015-03-13T07:51:36Z