1 Reply Latest reply: Jul 13, 2016 11:55 AM by akshata tare RSS

    One day per month

    Todd Johnston

      Hi All,

       

      I am trying to create some Headcount analysis in a Qlik Sense App.  My challenge is that every Wednesday, our SQL table (which populates a QVD) runs a snapshot of our current headcount.  These are labeled in the 'AsOfDate' field.  This is making it difficult to get a historical headcount per month as there might be up to 5 'AsOfDates' per month.  What I would like to do is isolate the first 'AsOfDate' per month to represent that month's headcount.  Any idea as to how I might accomplish this? 

       

      Thanks, in advance.

       

      TJ