topic Re: How to count a field value within a date range? in QlikView https://community.qlik.com/t5/QlikView/How-to-count-a-field-value-within-a-date-range/m-p/398829#M1160947 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Something along these lines depending on your date formatting:</P><P>count({ $&lt;start_date={'&gt;01-01-2012&lt;09-30-2012'}&gt;} distinct [Login ID])</P><P></P><P>However, if you want to make the date range dynamic, for example, current year or similar, here's a thread with another example:</P><P></P><P><A _jive_internal="true" class="loading" href="https://community.qlik.com/thread/55559">http://community.qlik.com/thread/55559</A></P></BODY></HTML> Sun, 04 Nov 2012 10:18:24 GMT Anonymous 2012-11-04T10:18:24Z How to count a field value within a date range? https://community.qlik.com/t5/QlikView/How-to-count-a-field-value-within-a-date-range/m-p/398828#M1160946 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I would like to define an Expression to count a field value within a date range.</P><P></P><P>That is...</P><P></P><P>If start_date &gt;= Jan 01, 2012 and &lt;= Sept 30, 2012, then count (distinct [Login ID]).</P><P></P><P>Can someone please advise the correct syntax as I am a new user of QlikView.&nbsp; Thank you.</P></BODY></HTML> Sun, 04 Nov 2012 09:29:44 GMT https://community.qlik.com/t5/QlikView/How-to-count-a-field-value-within-a-date-range/m-p/398828#M1160946 2012-11-04T09:29:44Z Re: How to count a field value within a date range? https://community.qlik.com/t5/QlikView/How-to-count-a-field-value-within-a-date-range/m-p/398829#M1160947 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Something along these lines depending on your date formatting:</P><P>count({ $&lt;start_date={'&gt;01-01-2012&lt;09-30-2012'}&gt;} distinct [Login ID])</P><P></P><P>However, if you want to make the date range dynamic, for example, current year or similar, here's a thread with another example:</P><P></P><P><A _jive_internal="true" class="loading" href="https://community.qlik.com/thread/55559">http://community.qlik.com/thread/55559</A></P></BODY></HTML> Sun, 04 Nov 2012 10:18:24 GMT https://community.qlik.com/t5/QlikView/How-to-count-a-field-value-within-a-date-range/m-p/398829#M1160947 Anonymous 2012-11-04T10:18:24Z