New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
New 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

 RecordID Team Usage Report Date 1 A Y 1/1/2018 2 B N 1/1/2018 3 C Y 1/1/2018 4 A N 2/1/2018 5 B Y 2/1/2018 6 C N 2/1/2018 7 A Y 3/1/2018 8 B Y 3/1/2018 9 C Y 3/1/2018 10 A N 4/1/2018 11 B N 4/1/2018 12 C Y 4/1/2018
Tags (2)
1 Solution

Accepted Solutions
Highlighted
MVP

Re: Count Max Date with Another Set Analysis Field

May be you are missing a closing parenthesis

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

3 Replies
Highlighted
MVP

Re: Count Max Date with Another Set Analysis Field

May be you are missing a closing parenthesis

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

Highlighted
New Contributor III

Re: Count Max Date with Another Set Analysis Field

Argh... Thank you!!!!!

Highlighted
Honored Contributor III