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.