title: KPI indicator for QlikView report update status. (Weekly and monthly updated)
body: <p>I have two reports, one that is updated monthly from the source, and one that is updated once per week.</p>
  
  <p>I have a KPI report that I want to show red/green indicators if the report is updated this month/this week.</p>
  
  <p>The last updated date is stored in a table and is loaded into QlikView. QVD_Id is the id of the QV report.</p>
  
  <p>The monthly report is beeing updated around the 10th each month. I have created this set analysis that seems to be "almost" working.</p>
  
  <pre><code>=if(Max({&lt;Day=, Date=, QVD_Id={1}, MonthCounter={"&lt;=$(#max(MonthCounter))"}&gt;} num(Date(Updated))-1,00) &gt;= num(Dato),0,1)
  </code></pre>
  
  <p>What I ultematly want for this indicator, is for it to be red if has not been updated within a month, or actually if its not updated within the 6th working day of the month it should be red(But this requered som additions to the dimensions that I can do later).</p>
  
  <p>I tried to do the same for the weekly report, but its not working:</p>
  
  <pre><code>=if(Max({&lt;Day=, Date=, QVD_Id={2}, WeekCounter={"&lt;=$(#max(WeekCounter))"}&gt;} num(Date(Updated))) &gt;= num(Dato),0,1)
  </code></pre>
  
  <p>What I want with the weekly updated report, is that it should be red if it's not updated by the 2nd day of the week(Tuesday).</p>
  
  <p>Example of the facttable used:</p>
  
  <pre><code>QVD_Id  TotalLoad   LoadYear    LoadMonth   LoadDay LoadHour    Updated                 Date_Lnr  Source
  1       200000      2014        2           5       10          .02.2014 10:56:31       19759     Source1
  </code></pre>
  
  <p>WeekCounter is 58 this week, and MonthCounter is 2. (WeekCounter is just continiuing from last year but that does not matter here).</p>
  
  <p>Hope any of you have some more experience then me with this and can find a solution for this.</p>