topic One day per month in App Development https://community.qlik.com/t5/App-Development/One-day-per-month/m-p/1142523#M20276 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am trying to create some Headcount analysis in a Qlik Sense App.&nbsp; My challenge is that every Wednesday, our SQL table (which populates a QVD) runs a snapshot of our current headcount.&nbsp; These are labeled in the 'AsOfDate' field.&nbsp; This is making it difficult to get a historical headcount per month as there might be up to 5 'AsOfDates' per month.&nbsp; What I would like to do is isolate the first 'AsOfDate' per month to represent that month's headcount.&nbsp; Any idea as to how I might accomplish this?&nbsp; </P><P></P><P>Thanks, in advance.</P><P></P><P>TJ</P></BODY></HTML> Wed, 13 Jul 2016 02:13:34 GMT 2016-07-13T02:13:34Z One day per month https://community.qlik.com/t5/App-Development/One-day-per-month/m-p/1142523#M20276 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am trying to create some Headcount analysis in a Qlik Sense App.&nbsp; My challenge is that every Wednesday, our SQL table (which populates a QVD) runs a snapshot of our current headcount.&nbsp; These are labeled in the 'AsOfDate' field.&nbsp; This is making it difficult to get a historical headcount per month as there might be up to 5 'AsOfDates' per month.&nbsp; What I would like to do is isolate the first 'AsOfDate' per month to represent that month's headcount.&nbsp; Any idea as to how I might accomplish this?&nbsp; </P><P></P><P>Thanks, in advance.</P><P></P><P>TJ</P></BODY></HTML> Wed, 13 Jul 2016 02:13:34 GMT https://community.qlik.com/t5/App-Development/One-day-per-month/m-p/1142523#M20276 2016-07-13T02:13:34Z Re: One day per month https://community.qlik.com/t5/App-Development/One-day-per-month/m-p/1142524#M20277 <HTML><HEAD></HEAD><BODY><P>How about taking the headcount End of each month? </P><P>Dim: Date(monthend(as of date), 'MMM-yyyy')</P><P>Measure: sum(headcount)</P><P></P><P>Is this what you are trying to accomplish? </P></BODY></HTML> Wed, 13 Jul 2016 15:55:31 GMT https://community.qlik.com/t5/App-Development/One-day-per-month/m-p/1142524#M20277 2016-07-13T15:55:31Z