Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Site utilization Continuous Week count

Hi All,

The scenario is that we have several sites which gets utilized and when  the current value goes above threshold value ,we get alert.

I have to find out for each site , the count of weeks starting from the current week when  it was continuously alert status without break of alert in any week.

Also data for a site comes into the table only when it has been alerted.

eg:

Site A was alerted for July 3rd week, July 2nd week but not on July 1 st week then count should be 2.

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.

Regards,

Jatin Kolhe.

1 Solution

Accepted Solutions
marcus_malinow
Not applicable

Re: Re: Re: Site utilization Continuous Week count

Try something like this:

3 Replies
Not applicable

Re: Site utilization Continuous Week count

Can you please post the sample data ?

Not applicable

Re: Re: Site utilization Continuous Week count

Hi ,

Please find attached sample data and output expected .

marcus_malinow
Not applicable

Re: Re: Re: Site utilization Continuous Week count

Try something like this: