One day per month

[#1]

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

[#2]

How about taking the headcount End of each month?

Dim: Date(monthend(as of date), 'MMM-yyyy')

Measure: sum(headcount)

Is this what you are trying to accomplish?