Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2017-03-21 08:24 PM

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?

272 Views
0 Likes
0 Replies