Need help with date range logic.

twills12 — Wed, 25 Nov 2020 16:16:04 GMT

Hello. I have an application that needs to show counts based upon the date the user selects. They can select a single month from the list box and the displayed counts should reflect that selected month's values.

The source data has a begin and end date on the records, so I want counts where the user selected month falls between these two date fields.

Team	Count	Begin Date	End Date
A	1	7/1/2019	6/30/2020
B	1	11/11/2019	11/11/2020

In this example, for Team A, I would want the count to reflect '1' if the user selects a date between July 2019 and June 2020, but anything before July 2019 for Team A would be '0' and anything after and including July 2020 would be '0'.

My attempts with set analysis isn't working. The count doesn't change when I switch in and out of that range.

=count({<DisplayDate = {">=$[Begin Date] <=$[End Date]"} >} [Team Name])

Re: Need help with date range logic.

Kushal_Chawda — Thu, 23 Jul 2020 20:41:42 GMT

try below

=count({<DisplayDate = {"=DisplayDate >=[Begin Date] and DisplayDate <=[End Date]"} >} [Team Name])

topic Need help with date range logic. in QlikView

Need help with date range logic.

Re: Need help with date range logic.