Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
brettaustin
Contributor III
Contributor III

Count Max Date with Another Set Analysis Field

I am trying to count the total teams with a 'Y' usage for the current reporting period.

WHERE the Usage Flag is 'Y'

AND

The Report Date is the maximum for the current 'reporting period'.  See below for data example

= count( {$< [Usage] = {"Y"}, [Report Date] = {"$(=Date(max([Report Date]))"}>}  RecordID)

Total Should equal 1 because the max date is 4/1/2018

  

RecordIDTeamUsageReport Date
1AY1/1/2018
2BN1/1/2018
3CY1/1/2018
4AN2/1/2018
5BY2/1/2018
6CN2/1/2018
7AY3/1/2018
8BY3/1/2018
9CY3/1/2018
10AN4/1/2018
11BN4/1/2018
12CY4/1/2018
1 Solution

Accepted Solutions
sunny_talwar

May be you are missing a closing parenthesis

=Count( {$< [Usage] = {"Y"}, [Report Date] = {"$(=Date(max([Report Date])))"}>}  RecordID)

View solution in original post

3 Replies
sunny_talwar

May be you are missing a closing parenthesis

=Count( {$< [Usage] = {"Y"}, [Report Date] = {"$(=Date(max([Report Date])))"}>}  RecordID)

brettaustin
Contributor III
Contributor III
Author

Argh... Thank you!!!!!

sasiparupudi1
Master III
Master III

if you got your answer, please close this thread by marking a correct and any helpful answers