Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Count within date range

I have two tables - one contains a list of customers, countries, order dates, and delivery dates.  The other contains a list of all possible countries and delivery deadlines.  I want to determine the number of orders that were filled within the deadline by country.  Orders filled after the deadline should be ignored.

The following counts the orders filled, but does not ignore the orders filled after the deadline.

Count({<Delivered={'<=$(=lookup('Deadline','Active Countries',[Order Country]))'}>}[Delivered])

What am I missing to properly exclude the delivery dates that fall after the deadline?