topic Site utilization Continuous Week count in QlikView https://community.qlik.com/t5/QlikView/Site-utilization-Continuous-Week-count/m-p/722023#M673943 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>The scenario is that we have several sites which gets utilized and when&nbsp; the current value goes above threshold value ,we get alert.</P><P>I have to find out for each site , the count of weeks starting from the current week when&nbsp; it was continuously alert status without break of alert in any week.</P><P>Also data for a site comes into the table only when it has been alerted.</P><P>eg: </P><P>Site A was alerted for July 3rd week, July 2nd week but not on July 1 st week then count should be 2.</P><P>Site B was alerted for July 3rd week, July 2nd week, July 1 st week,June 4th week ,June 3rd week but not on June 2nd week ,again alert came on june 1st week still then count should be 5.</P><P></P><P>Regards,</P><P></P><P>Jatin Kolhe.</P></BODY></HTML> Tue, 22 Jul 2014 05:28:37 GMT 2014-07-22T05:28:37Z Site utilization Continuous Week count https://community.qlik.com/t5/QlikView/Site-utilization-Continuous-Week-count/m-p/722023#M673943 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>The scenario is that we have several sites which gets utilized and when&nbsp; the current value goes above threshold value ,we get alert.</P><P>I have to find out for each site , the count of weeks starting from the current week when&nbsp; it was continuously alert status without break of alert in any week.</P><P>Also data for a site comes into the table only when it has been alerted.</P><P>eg: </P><P>Site A was alerted for July 3rd week, July 2nd week but not on July 1 st week then count should be 2.</P><P>Site B was alerted for July 3rd week, July 2nd week, July 1 st week,June 4th week ,June 3rd week but not on June 2nd week ,again alert came on june 1st week still then count should be 5.</P><P></P><P>Regards,</P><P></P><P>Jatin Kolhe.</P></BODY></HTML> Tue, 22 Jul 2014 05:28:37 GMT https://community.qlik.com/t5/QlikView/Site-utilization-Continuous-Week-count/m-p/722023#M673943 2014-07-22T05:28:37Z Re: Site utilization Continuous Week count https://community.qlik.com/t5/QlikView/Site-utilization-Continuous-Week-count/m-p/722024#M673944 <HTML><HEAD></HEAD><BODY><P>Can you please post the sample data ?</P></BODY></HTML> Tue, 22 Jul 2014 18:08:42 GMT https://community.qlik.com/t5/QlikView/Site-utilization-Continuous-Week-count/m-p/722024#M673944 2014-07-22T18:08:42Z Re: Re: Site utilization Continuous Week count https://community.qlik.com/t5/QlikView/Site-utilization-Continuous-Week-count/m-p/722025#M673945 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>Please find attached sample data and output expected .</P></BODY></HTML> Wed, 23 Jul 2014 09:20:25 GMT https://community.qlik.com/t5/QlikView/Site-utilization-Continuous-Week-count/m-p/722025#M673945 2014-07-23T09:20:25Z Re: Re: Re: Site utilization Continuous Week count https://community.qlik.com/t5/QlikView/Site-utilization-Continuous-Week-count/m-p/722026#M673946 <HTML><HEAD></HEAD><BODY><P>Try something like this:</P></BODY></HTML> Wed, 23 Jul 2014 09:48:00 GMT https://community.qlik.com/t5/QlikView/Site-utilization-Continuous-Week-count/m-p/722026#M673946 marcus_malinow 2014-07-23T09:48:00Z