Discussion Board for collaboration on QlikView Scripting.
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.
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.
Go to Solution.
Try something like this:
Can you please post the sample data ?
Please find attached sample data and output expected .