How to count a field value within a date range?

[#1]

Hi,

I would like to define an Expression to count a field value within a date range.

That is...

If start_date >= Jan 01, 2012 and <= Sept 30, 2012, then count (distinct [Login ID]).

Can someone please advise the correct syntax as I am a new user of QlikView.  Thank you.

[Anonymous]

Hi,

Something along these lines depending on your date formatting:

count({ $<start_date={'>01-01-2012<09-30-2012'}>} distinct [Login ID])

However, if you want to make the date range dynamic, for example, current year or similar, here's a thread with another example:

http://community.qlik.com/thread/55559