Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?